administrators Reply Quote

Answer : Explanation : 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.

Click here to see the full blog post