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

• Basic LOOP Statement

• CASE Statement

• CLOSE Statement

• Collection

• Collection Method Call

• Comment

• Constant

• CONTINUE Statement

• Cursor FOR LOOP Statement

• Cursor Variable

• DELETE Statement Extension

• EXCEPTION_INIT Pragma

• Exception

• Exception Handler

• EXECUTE IMMEDIATE Statement

• EXIT Statement

• Explicit Cursor

• Expression

• FETCH Statement

• FOR LOOP Statement

• FORALL Statement

• Function

• GOTO Statement

• IF Statement

• Implicit Cursor Attribute

• INLINE Pragma

• INSERT Statement Extension

• Literal

• Named Cursor Attribute

• NULL Statement

• OPEN Statement

• OPEN FOR Statement

• Parameter

• Procedure

• RAISE Statement

• Record

• RESTRICT_REFERENCES Pragma (deprecated)

• RETURN Statement

• RETURNING INTO Clause

• %ROWTYPE Attribute

• SELECT INTO Statement

• SERIALLY_REUSABLE Pragma

• SQLCODE Function

• SQLERRM Function

• %TYPE Attribute

• UPDATE Statement Extensions

• Variable

• WHILE LOOP Statement