Oracle PL/SQL Articles
Introduction to PL/SQL - A brief overview of some of the important points you should consider when first trying to learn PL/SQL.
PL/SQL : Stop Making the Same Performance Mistakes - This article describes the
Oracle PL/SQL Articles
Introduction to PL/SQL - A brief overview of some of the important points you should consider when first trying to learn PL/SQL.
PL/SQL : Stop Making the Same Performance Mistakes - This article describes the common PL/SQL performance mistakes I see people making time and time again.
Bulk Binds - Improve performance by reducing the overhead associated with context switches between the PL/SQL and SQL engines.
Collections in Oracle PL/SQL - Use collections in PL/SQL to perform array processing.
Complex Recordsets - Build complex recordsets using temporary or PL/SQL tables within stored procedures.
Data Encryption - DBMS_OBFUSCATION_TOOLKIT - Encrypt and decrypt data using the DBMS_OBFUSCATION_TOOLKIT package.
DBMS_APPLICATION_INFO - Track session and long operation act