SQLPlus Column

COLUMN command Specifies display characteristics for a given column or lists the current display characteristics for a single column or for all columns.

COLUMN Command Syntax:

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

option is one of the next 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]

COLUMN Command Examples:

COLUMN NAME FORMAT A20 HEADING ‘CUSTOMER|NAME’

COLUMN AMOUNT FORMAT $9,999,990.99

COLUMN PRICE+COMMISSION+TAX_EXPENSES ALIAS AMOUNT
COLUMN AMOUNT FORMAT $9,999,999.99 NULL ‘

If you don’t specify any option of the command COLUMN, it will display the current settings for a column (COLUMN column_name) or for all columns (COLUMN).