Allows you to include more than one SQL statement in an SQL
module procedure or in an embedded SQL program. Only by defining
a compound statement can you put multiple SQL statements in
a procedure. Procedures that contain one or more compound
statements are called multistatement procedures.
In contrast, a simple statement can contain a single SQL
statement only. Procedures that contain a single SQL statement
are called simple-statement procedures. See the Simple_Statement
for a description of simple-statement procedures and how you use
them in SQL application programming.
A compound statement and a simple statement differ not just
in the number of SQL statements they can contain. A compound
statement:
o Can include only a subset of the SQL statements allowed in a
simple statement procedure. (See the compound-use-statement
syntax diagram for a list of these valid statements.)
o Can include control flow statements, much like those you can
use in a host language program. (See the control-statement
syntax diagrams for a list of flow control statements allowed
in a compound statement.)
o Can include transaction management statements, such as
ROLLBACK and COMMIT.
o Can include local variables.
o Can control atomicity.
o Can reference only one alias because each compound statement
represents a single Oracle Rdb request.
See the Oracle Rdb Guide to SQL Programming for a conceptual
description of compound statements and their relationship to
multistatement procedures.
Additional Information:
explode
extract