7.2. Block Header

Except for anonymous blocks, all PL/SQL blocks begin with a block header. The general syntax of the PL/SQL block header is:

{{PROCEDURE | FUNCTION} name IS |  <<name>> }

7.2.1. Keywords

PROCEDURE

Indicates that the block is a PL/SQL procedure.

FUNCTION

Indicates that the block is a PL/SQL function.

name

Specifies the name to be assigned to the block. If used to create a named block, then the name appears within pairs of angle brackets (<< >>) and the IS keyword is omitted.

Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.