13 PL/SQL Language Elements

This chapter 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 in this chapter, see Oracle Database SQL Language Reference.

Topics

• Assignment Statement

• AUTONOMOUS_TRANSACTION Pragma

• Basic LOOP Statement

• Block

• CASE Statement

• CLOSE Statement

• Collection Variable Declaration

• Collection Method Invocation

• Comment

• Constant Declaration

• CONTINUE Statement

• Cursor FOR LOOP Statement

• Cursor Variable Declaration

• DELETE Statement Extension

• 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

• INSERT Statement Extension

• Named Cursor Attribute

• NULL Statement

• OPEN Statement

• OPEN FOR Statement

• PIPE ROW Statement

• Procedure Declaration and Definition

• RAISE Statement

• Record Variable Declaration

• RESTRICT_REFERENCES Pragma (deprecated)

• RETURN Statement

• RETURNING INTO Clause

• %ROWTYPE Attribute

• Scalar Variable Declaration

• SELECT INTO Statement

• SERIALLY_REUSABLE Pragma

• SQLCODE Function

• SQLERRM Function

• %TYPE Attribute

• UPDATE Statement Extensions

• WHILE LOOP Statement