Question

Distinguish between a static report and dynamic report in sql

Answer 1

Answer:

We cannot use some of the SQL statements Dynamically. Performance of these statements is poor as compared to Static SQL.

...

Difference between Static and Dynamic SQL.

Static (Embedded) SQL Dynamic (Interactive) SQL

It is more swift and efficient. It is less swift and efficient.

SQL statements are compiled at compile time. SQL statements are compiled at run time.