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 ...
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
