Name
SET TERMOUT â Not available in iSQL*Plus
Synopsis
The TERMOUT setting controls whether SQL*Plus displays output generated by SQL statements, PL/SQL blocks, and SQL*Plus commands. This setting applies only when SQL*Plus is executing a script file. SQL*Plus displays output from commands entered interactively.
Syntax
SET TERM[OUT] {OFF | ON}Parameters
- SET TERM[OUT]
Is the command, which may be abbreviated SET TERM.
- OFF
Turns off terminal output.
- ON
Turns on terminal output. This is the default setting.
Terminal output is often turned off while a command file is running to keep the user's screen from becoming cluttered with query output and feedback messages.
Get Oracle SQL*Plus: The Definitive Guide, 2nd Edition 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.
