21st Century PL/SQL

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
• Operators
• Loops, conditionals, other control logic
• Performance-related Issues
• Program unit construction and structure
• Dependency management
• Packages
• Parameter lists
• 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