O'Reilly logo

Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts by John Adolph Palinski

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Code Block Components and Block Labels

A PL/SQL code block can consist of several section types and can contain nested code blocks. This section will discuss the various code block sections, nested code blocks, and the GOTO keyword.

Code Block Sections

There are four types of code block sections:

•Header This is the optional first section of the code block. It is used to identify the type of code block and its name. The code block types are anonymous procedure, named procedure, and function. A header is used for only the latter two types.
•Declaration This is an optional section of the code block. It contains the name of the local objects that will be used in the code block. These include variables, cursor definitions, and exceptions. This ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required