Dynamic SQL in DBMS

Here you will learn about dynamic sql in dbms. What is Dynamic SQL? When the pattern of database access is known in advance then static SQL is very adequate to serve us. Sometimes, in many applications we may not know the pattern of database access in advance. For example, a report writer must be able to decide …

Dynamic SQL in DBMS Read More »

Embedded SQL (Static SQL) in DBMS

The structured query language provides us 2 features: It allows us to write queries. It allows us to use it in programming languages so that database can be accessed through application programs also. Due to this duality SQL is sometimes called dual mode language. Actually all the queries can’t be expressed in SQL alone. There …

Embedded SQL (Static SQL) in DBMS Read More »