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