The PRINT command is used to display the value of a bind variable. One of its most useful applications is to retrieve and print data from a REFCURSOR variable which has been opened within a PL/SQL block or returned from a PL/SQL procedure. PRINT is discussed in Chapter 7 .
PRI[NT] [bind_variable_name]where:
- PRI[NT]
Is the command, which may be abbreviated to PRI.
- bind_variable_name
Is the name of the bind variable you want to print. If you omit a name, the values of all bind variables are printed.
Get Oracle SQL*Plus: The Definitive Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
