Oracle SET command

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 Run command is whether to display statements
Sql> set feedback on; Set 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; Displays the execution result of the command in the script, which is on by default
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
Set verify off//can turn off and turn on the display of the prompt confirmation information old 1 and new 1.

Oracle SET command