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
Sql>set Numwidth 12; Output Number Type field length, default is ten
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's set of bits and pieces, here's a summary
sql> set timing on; Set display "Time used: XXXX"

sql> set Autotrace on-; Settings allow parsing of executed SQL

sql> set trimout on;//Remove trailing spaces per line for standard output, default to OFF

sql> set Trimspool on;//Remove redirect (spool) output trailing space per line, default is off

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

sql> set echo off;//Displays each SQL command in a script started by the start, default to on

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 COLSEP ";//Output delimiter

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

sql> set Numwidth 12; Output Number Type field length, default is ten

sql> set Termout off; Displays the execution result of the command in the script, which is on by default

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

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

Note that the column command

Col[umn] [{column | expr} [option ...]]

Where option is one of the following clauses:

Ali[as] Alias

Cle[ar]

Entmap {on| OFF}

Fold_a[fter]

Fold_b[efore]

For[mat] Format

hea[ding] Text

Jus[tify] {L[eft] | C[enter] | C[entre] | R[ight]}

Like {expr | alias}

Newl[ine]

new_v[alue] Variable

Nopri[nt] | PRI[NT]

Nul[l] Text

old_v[alue] Variable

on| OFF

wra[pped] | Wor[d_wrapped] | Tru[ncated]

Here's an example:

sql> COLUMN SAL ALIAS Salary FORMAT $99,990.90

we specify a name for the SAL column and the money display format for the numbers.

sql> Col title format A20;

Oracle SET command