SQL* Plus CLI  «Prev  Next»

Oracle Column Command

The COLUMN command in Oracle

Here are the correct matches.
WORD_WRAPPED Causes text in a column to wrap at word boundaries
TRUNCATED Truncates columns with text values longer that the column’s display width
JUSTIFY LEFT Forces a heading to print flush with the left edge of the column
HEADING (HEA) Used to define your own heading for a column
WRAPPED Tells text in a column to wrap when the column width is reached
FORMAT (FOR) Used to define a display format for a column


COL[UMN] [{column | expr} [option ...]]
where option represents one of the following clauses:
ALI[AS] alias
FOR[MAT] format
HEA[DING] text
LIKE {expr | alias}
NEW_V[ALUE] variable
NUL[L] text
OLD_V[ALUE] variable

Specifies display attributes for a given column, such as
  1. text for the column heading
  2. alignment of the column heading
  3. format for NUMBER data
  4. wrapping of column data

Also lists the current display attributes for a single column or all columns. Enter COLUMN followed by column or expr and no other clauses to list the current display attributes for only the specified column or expression. Enter COLUMN with no clauses to list all current column display attributes.


{column | expr}

Identifies the data item (typically, the name of a column) in a SQL SELECT command to which the column command refers. If you use an expression in a COLUMN command, you must enter expr exactly as it appears in the SELECT command. If the expression in the SELECT command is a+b, for example, you cannot use b+a or (a+b) in a COLUMN command to refer to the expression in the SELECT command. If you select columns with the same name from different tables, a COLUMN command for that column name will apply to both columns. That is, a COLUMN command for the column LAST_NAME applies to all columns named LAST_NAME that you reference in this session. COLUMN ignores table name prefixes in SELECT commands. Also, spaces are ignored unless the name is placed in double quotes. To format the columns differently, assign a unique alias to each column within the SELECT command itself (do not use the ALIAS clause of the COLUMN command) and enter a COLUMN command for each column's alias.

ALI[AS] alias

Assigns a specified alias to a column, which can be used to refer to the column in BREAK, COMPUTE, and other COLUMN commands.


Resets the display attributes for the column to default values. To reset the attributes for all columns, use the CLEAR COLUMNS command. CLEAR COLUMNS also clears the ATTRIBUTEs for that column.


Enables entity mapping to be turned on or off for selected columns in HTML output. This feature enables you to include, for example, HTML hyperlinks in a column of data, while still mapping entities in other columns of the same report. By turning entity mapping off for a column containing HTML hyperlinks, the HTML anchor tag delimiters, <, >, " and &, are correctly interpreted in the report. Otherwise they would be replaced with their respective entities, <, >, " and &, preventing web browsers from correctly interpreting the HTML.
Entities in the column heading and any COMPUTE labels or output appearing in the column are mapped or not mapped according to the value of ENTMAP for the column.
The default setting for COLUMN ENTMAP is the current setting of the MARKUP HTML ENTMAP option.