Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET AUTOPRINT

Synopsis

The AUTOPRINT setting controls whether SQL*Plus automatically prints the contents of any bind variables referenced by a PL/SQL block after it executes.

Syntax

SET AUTOP[RINT] {OFF | ON}

Parameters

SET AUTOP[RINT]

Is the command, which may be abbreviated SET AUTOP.

OFF

Keeps bind variables from being automatically printed after being referenced by a PL/SQL block. This is the default setting.

ON

Causes bind variables to be printed automatically, following the execution of any PL/SQL block or SQL statement that references them.