SHOWMODE |
SHOW[MODE] ON | OFF
|
Controls whether SQL*Plus lists the old and new settings of a SQL*Plus system variable when the SET command is used.
Keywords
ON
Causes SQL*Plus to list settings when a change is made. (This option results in the same behavior as the now obsolete SHOWMODE BOTH command.)
OFF
Suppresses listing of old and new settings when a change is made. This option is the default.
Get Oracle SQL: the Essential Reference 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.