SQL Plus Tutorial

SQL*Plus COLUMN Command

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 ...]]

where option represents 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]

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).