21st Century PL/SQL
Your chance to influence the direction of the Oracle PL/SQL language.
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
Recent Entries
- Ability to write binaries
- CRUD in USER_DEPENDENCIES
- Allow certain DDL SQLs without recourse to dynamic SQL
- Allow RETURNING for INSERT....SELECT
- Optimisation of array processing
- Incremental bulk processing
- Add ERROR_MESSAGE to SQL%BULK_EXCEPTIONS
- Remove implementation restriction on FORALL collections of records
- Add Unit Test support