Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| plsql_static_dynamic_sql [2020/06/04 15:39] – [Describe Unknown No of Column] andonovj | plsql_static_dynamic_sql [2020/06/04 15:41] (current) – [Differences] andonovj | ||
|---|---|---|---|
| Line 162: | Line 162: | ||
| </ | </ | ||
| - | ====Describe Unknown No of Column==== | + | ====Describe Unknown No. of Columns==== |
| One advantage of the DBMS_SQL over the Native Dynamic SQL is the ability to work with: | One advantage of the DBMS_SQL over the Native Dynamic SQL is the ability to work with: | ||
| Line 299: | Line 299: | ||
| * Used for: Dynamic Queries and Sorts (Queries which can change depending on the user's preferences) | * Used for: Dynamic Queries and Sorts (Queries which can change depending on the user's preferences) | ||
| * DDL can be used, unlike Static SQL | * DDL can be used, unlike Static SQL | ||
| + | |||
| + | In general, you should use DBMS_SQL dynamic SQL, only when you don't know the number of columns or bind variables which will be used in a select, for every other occasion, use the Native Dynamic SQL. | ||