| 29. 4. 1. Reporting Tools in Oracle's SQL*Plus: COLUMN |
|
|
Change the way a column displays by using the COLUMN command |
The COLUMN command has the following syntax: |
COLUMN column-name FORMAT format-specification |
where |
column-name is the column heading you wish to format. |
The format-specification uses a's for text and 9's for numbers, like this: |
an - text format for a field width of n |
9n - numeric format with no decimals for a field width of numbers of size n |