Static and dynamic SQL
|
|
|
Question / Problem
|
What is basic difference between Static and Dynamic SQL
|
Solution
|
Static SQL is compiled and optimized prior to its execution while Dynamic is compiled and optimized during execution.
|
Applies to |
|
Oracle 9i Sql
|
Rank It |
|
