21st Century PL/SQL
Your chance to influence the direction of the Oracle PL/SQL language.
SQL processing inside PL/SQL > Dynamic SQL and Dynamic PL/SQL
Ideas within Dynamic SQL and Dynamic PL/SQL
| Top Vote Getters | Top Scorers |
|---|---|
April 06, 2005
Allow certain DDL SQLs without recourse to dynamic SQL
Probably more valuable with data-warehouse large data imports and big queries:
TRUNCATE table, enable/disable constraints and index unusable/rebuild.
ALTER TABLE...LOCATION... for external tables
Also, it would be nice to do ALTER SESSION SET NLS.... without recourse to dynamic SQL.
Posted by gary myers at 12:21 AM | Add your thoughts (1)
Sidebar Template
Search Template
Search 21st Century PL/SQL
Actions Template
Actions
Ideas List Template
Browse Categories
- Built-in (Supplied) Packages
- DBMS_LOB
- DBMS_OUTPUT
- New built-in packages
- modplsql
- UTL_FILE
- UTL_MAIL
- Data structures and datatypes
- Built-in Procedures and Functions
- Collections
- adding two collections in runtime
- Dates, timestamps, intervals, etc.
- Numbers
- Object types
- String manipulation
- Exception handling
- exception
- General and Miscellaneous issues
- Loops, conditionals, other control logic
- Performance-related Issues
- Program unit construction and structure
- SQL processing inside PL/SQL
- Bulk processing FORALL and BULK COLLECT
- DML Operations (INSERT, UPDATE, DELETE)
- Dynamic SQL and Dynamic PL/SQL
- Querying data in PL/SQL
- Querying with REF CURSORS (cursor variables)
- Transaction management