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

• Block

• CASE Statement

• CLOSE Statement

• Collection

• Collection Method Call

• Comment

• Constant

• CONTINUE Statement

• Cursor Attribute

• Cursor Variable Declaration

• EXCEPTION_INIT Pragma

• Exception Declaration

• Exception Handler

• EXECUTE IMMEDIATE Statement

• EXIT Statement

• Explicit Cursor

• Expression

• FETCH Statement

• FORALL Statement

• Function Declaration and Definition

• GOTO Statement

• IF Statement

• INLINE Pragma

• Literal

• LOOP Statements

• NULL Statement

• OPEN Statement

• OPEN-FOR Statement

• Parameter Declaration

• Procedure Declaration and Definition

• RAISE Statement

• Record Definition

• RESTRICT_REFERENCES Pragma (deprecated)

• RETURN Statement

• RETURNING INTO Clause

• %ROWTYPE Attribute

• SELECT INTO Statement

• SERIALLY_REUSABLE Pragma

• SQL (Implicit) Cursor Attribute

• SQLCODE Function

• SQLERRM Function

• %TYPE Attribute

• Variable