Oracle SQLPLUS Common Set settings

Sql>set Colsep '; -Field Output delimiter

Sql>set echo off; Displays each SQL command in the script started by the start, which defaults to on

sql> set echo on //Set whether the Run command is to Display statements

Sql> set feedback on; / / settings display "xx row selected"

Sql>set feedback off; //echo the number of record bars processed by this SQL command, default to On

Sql>set heading off; Output field header, default to On

Sql>set pagesize 0; //output number of rows per page, default is 24, in order to avoid paging, can be set to 0.

Sql>set Linesize 80; //output one line of characters, default is 80

Sql>set Numwidth 12; //Output Number Type field length, default is 10

Sql>set termout off; //Show execution results of commands in script, default to On

Sql>set trimout on; Remove trailing spaces per line of standard output, default to Off

Sql>set Trimspool on; Remove redirect (spool) output trailing spaces per line, default to OFF

Sql>set serveroutput on; Set allow display output similar to Dbms_output

Sql> set timing on; //Set display "Time used: XXXX"

Sql> set autotrace on; //settings allow parsing of executed SQL

sql> set Verify off; / / You can turn off and turn on the display of the prompt confirmation information old 1 and new 1.

Export Results to text:

Spool<spool_flat_file>
Example: Spool D:\Spool_flatquery.txt
In this way, Sql*plus will assign all the output and commands on the screen to the file.

Executes the query output. At this point, the system does not save the results to a file, but instead saves them in a buffer.

After the query is finished, close the file. The command format is: Spool off.

Oracle SQLPLUS Common Set settings