Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL PLUS Session Environment

 

Reporting Tools in Oracles SQLPlus

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