Select query formatting

From MyWiki
Jump to: navigation, search

http://docs.oracle.com/cd/A87860_01/doc/server.817/a82950/ch4.htm#1001125

set underline =
set underline -

COLUMN ENAME FORMAT A4


SQL> COLUMN COMM LIKE SAL HEADING Bonus

To list the current display attributes for a given column, use the COLUMN command followed by the column name only, as shown below:
COLUMN column_name
To list the current display attributes for all columns, enter the COLUMN command with no column names or clauses after it:
COLUMN
To reset the display attributes for a column to their default values, use the CLEAR clause of the COLUMN command as shown below:
COLUMN column_name CLEAR
To reset the attributes for all columns, use the COLUMNS clause of the CLEAR command.