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