Searching for "Embeded"

Q:

Difference between Embeded SQL and Dynamic SQL?

Answer

Static (embedded) SQL:


1.In static SQL how database will be accessed is predetermined in the embedded SQL statement.


2.It is more swift and efficient.


3.SQL statements are compiled at compile time.


4.Parsing, validation, optimization, and generation of application plan are done at compile time.


5.It is generally used for situations where data is distributed uniformly.


6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are not used.


7. It is less flexible 


 


Dynamic (interactive) SQL:


1.In dynamic SQL, how database will be accessed is determined at run time.


2.It is less swift and efficient.


3.SQL statements are compiled at run time.


4.Parsing, validation, optimization, and generation of application plan are done at run time.


5.It is generally used for situations where data is distributed non-uniformly.


6.EXECUTE IMMEDIATE, EXECUTE and PREPARE statements are used.


7.It is more flexible.

Report Error

View answer Workspace Report Error Discuss