Parameters
- column_name
Name of the column you are formatting. If it is a computed column, the expression is the name. If your SELECT statement aliases the column, you must use that alias name here. Issuing the command COLUMN column_name with no further parameters causes SQL*Plus to display the current format for that column.
- ALI[AS]
Allows you to specify an alternate name for the column that is meaningful.
- alias
Alternate name for the column that may be used in BREAK commands, COMPUTE commands, and other COLUMN commands.
- CLE[AR]
Erases any format settings for the column in question.
- ENTMAP (ON | OFF)
Controls whether characters such as < and > should be represented as < and > in HTML reports. The default is to use the ENTMAP setting specified with the SET MARKUP command or -M command-line option.
- FOLD_A[FTER]
Causes SQL*Plus to advance to a new line after printing this column.
- FOLD_B[EFORE]
Causes SQL*Plus to advance to a new line before this column is printed.
- FOR[MAT]
Allows you to control how the data for the column is displayed.
- format_spec
String that specifies the display format for the column.
- HEA[DING]
Allows you to define a heading for the column.
- heading_text
Text you want for the column heading. This may optionally be enclosed in either single or double quotes.
- JUS[TIFY] (LEFT | CENTER | CENTRE | RIGHT)
Controls where the heading text prints relative to the column width. By default, headings for numeric fields print flush right, and headings for text fields print flush ...