SQL Plus - TERMOUT

Card Puncher Data Processing

About

Termout is a system variable that controls the display of output in the console generated by commands executed from a script.

If termout is off, no output will be send to the console (included the result of a SQL) but the output will appears within the file generated by a SPOOL command.

Syntax

SET TERM[OUT] {ON | OFF}





Discover More
Card Puncher Data Processing
SQL Plus - Csv Export

How to export a CSV with SQL Plus. Export of the tables all_objects where:
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...



Share this page:
Follow us:
Task Runner