SQL$HELP72.HLB  —  Compound Stmt
    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
Environment Format Arguments Examples
Close Help