SQL*PLUS - COLUMN Statement

Specify text, alignment, format and wrapping for a given column, for the duration of the current session.

Syntax:

   COL[UMN] [{column|expr} [option …]] 

options:

ALIAS alias      Assign an alias to a column, which can be used by
                 BREAK, COMPUTE, and other COLUMN commands.
                 COL em_salary+em_bonus ALIAS tot_income

CLEAR            Reset the display attributes for the column to default.

FOLD_AFTER       Inserts a CR after the col heading and after each row. 
FOLD_BEFORE      Inserts a CR before the col heading and before each row.

FORMAT format    Format a column (e.g. COL emp_name FORMAT A15)

HEA[DING] 'text' Set a column heading

JUSTIFY {L[EFT]|C[ENTER]|C[ENTRE]|R[IGHT]}
                 By default Numbers are right justified, text is left justified.

LIKE {expr|alias}
                 Format like another column (already defined)

NEWLINE          Same as FOLD_BEFORE
    
NEW_VALUE variable
                 Specify a variable to hold a column value. (see TTITLE)

NOPRINT|PRINT    Display the column

NUL[L] char      Display NULL values as Char

OLD_VALUE variable
                 Specify a variable to hold a column value. (see BTITLE)

ON|OFF           Enable or disable column format attributes

WRA[PPED]|WOR[D_WRAPPED]|TRU[NCATED] 
                 How to treat long CHAR strings

Note:
expressions like 'em_salary+em_bonus' must match exactly the SELECT statement being run.
If no option is specified, COLUMN will list the current attributes.

Related Commands:

to_char
SET NUMWIDTH - default width for Number columns
SET LONG - default width for LONG columns
SET LONGCHUNKSIZE - default width for LONG columns
SET MAXDATA - Max width for columns


© Copyright SS64.com 1999-2013
Some rights reserved