Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
| plsql_static_dynamic_sql [2020/06/04 15:40] – andonovj | plsql_static_dynamic_sql [2020/06/04 15:41] (current) – [Differences] andonovj | ||
|---|---|---|---|
| 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. | ||