SQL$HELP72.HLB  —  PRINT  Examples
    Example 1: Displaying a literal from a command procedure

    The following PRINT statement in a command procedure displays
    'Creating trigger definitions for the database' during the
    execution of the command procedure:

    SQL> -- Trigger definition statements are next.
    SQL> PRINT 'Creating trigger definitions for the database';
    SQL> CREATE TRIGGER EMPLOYEE_ID_CASCADE_DELETE
       .
       .
       .

    Example 2: Displaying a variable

    The following PRINT statement displays the definition of a
    variable:

    SQL> DECLARE :X CHAR(10);
    SQL> BEGIN
    cont>   SET :X = 'Active';
    cont> END;
    SQL> PRINT :X;
     X
     Active
Close Help