Difference between revisions of "Select query formatting"
From MyWiki
| Line 10: | Line 10: | ||
To list the current display attributes for a given column, use the COLUMN command followed by the column name only, as shown below:<br> | To list the current display attributes for a given column, use the COLUMN command followed by the column name only, as shown below:<br> | ||
| − | COLUMN | + | ''COLUMN column_nam''e<br> |
To list the current display attributes for all columns, enter the COLUMN command with no column names or clauses after it:<br> | To list the current display attributes for all columns, enter the COLUMN command with no column names or clauses after it:<br> | ||
COLUMN<br> | COLUMN<br> | ||
Revision as of 10:28, 21 June 2015
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.
