Summarizes the syntax and semantics of PL/SQL language elements and provides links to examples and related topics.

For instructions for reading the syntax diagrams, see Oracle Database SQL Language Reference.

• ACCESSIBLE BY Clause

• AGGREGATE Clause

• Assignment Statement

• AUTONOMOUS_TRANSACTION Pragma

• Basic LOOP Statement

• Block

• Call Specification

• CASE Statement

• CLOSE Statement

• Collection Method Invocation

• Collection Variable Declaration

• Comment

• COMPILE Clause

• Constant Declaration

• CONTINUE Statement

• COVERAGE Pragma

• Cursor FOR LOOP Statement

• Cursor Variable Declaration

• Datatype Attribute

• DEFAULT COLLATION Clause

• DELETE Statement Extension

• DEPRECATE Pragma

• DETERMINISTIC Clause

• Element Specification

• EXCEPTION_INIT Pragma

• Exception Declaration

• Exception Handler

• EXECUTE IMMEDIATE Statement

• EXIT Statement

• Explicit Cursor Declaration and Definition

• Expression

• FETCH Statement

• FOR LOOP Statement

• FORALL Statement

• Formal Parameter Declaration

• Function Declaration and Definition

• GOTO Statement

• IF Statement

• Implicit Cursor Attribute

• INLINE Pragma

• Invoker’s Rights and Definer’s Rights Clause

• INSERT Statement Extension

• Named Cursor Attribute

• NULL Statement

• OPEN Statement

• OPEN FOR Statement

• PARALLEL_ENABLE Clause

• PIPE ROW Statement

• PIPELINED Clause

• Procedure Declaration and Definition

• RAISE Statement

• Record Variable Declaration

• RESTRICT_REFERENCES Pragma (deprecated)

• RETURN Statement

• RETURNING INTO Clause

• RESULT_CACHE Clause

• %ROWTYPE Attribute

• Scalar Variable Declaration

• SELECT INTO Statement

• SERIALLY_REUSABLE Pragma

• SHARING Clause

• SQLCODE Function

• SQLERRM Function

• %TYPE Attribute

• UDF Pragma

• UPDATE Statement Extensions

• WHILE LOOP Statement