Oracle | PL/SQL Topics

Oracle PL/SQL Topics Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose

This page is a collection of links related to the coding, debugging, and tuning of code written in PL/SQL. Many library pages are pointed to multiple times as I have tried to list many of the keywords associated with, in some cases, the same topic and demos (Oracle keywords are capitalized). A subset of built-in PL/SQL packages is also identified that are major assets in PL/SQL development.

Library Page Links

Accessible By Clause
ADD BINDING Clause
ALTER SESSION DISABLE COMMIT IN PROCEDURE
Anonymous Blocks
Array Processing
AUTHID
Autonomous Transactions
Bidirectional Cursors
Built-in Packages
BULK COLLECT
Compound Triggers

Conditional Compilation
Constants
Continue Statement
Control Structures
CROSSEDITION Triggers
CURRENT_USER
Cursor Loops
Data Dictionary
DBMS_APPLICATION_INFO
DBMS_ASSERT
DBMS_CRYPTO
DBMS_DB_VERSION
DBMS_DDL
DBMS_LOB
DBMS_LOG (new in 12c)
DBMS_OUTPUT
DBMS_SESSION
DBMS_SQL
DBMS_UTILITY
DDL Event Triggers
DEFINER Rights
DETERMINISTIC
Dynamic SQL: See DBMS_SQL, Native Dynamic SQL, and REF CURSOR
Edition Based Redefinition
Encryption: See DBMS_DDL and WRAP
Exception Handling
Exceptions: User Defined
EXIT
FETCH FIRST (new in 12c)
FIPS Flagging
FOLLOWS Clause: See CROSSEDITION Triggers and Table Triggers
FOR loops
FORALL
GOTO
Functions
IF Statements
IN INDICES OF
Initialization Section
INSTEAD OF Triggers
Interpreted Compilation
Java Functions and Procedures
Labels
LIMIT Clause
Locator Variables
Loops
Multidimensional Collections
Mutating Triggers
Named Exceptions
Native Compilation
Native Dynamic SQL
Nested Loops
NOCOPY Compiler Hint

PRAGMA INLINE
PRAGMA SERIALLY REUSABLE