René Nyffenegger's collection of things on the web | |
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
|
column [SQL*Plus] | ||
SQL> column colum_name alias alias_name SQL> column colum_name clear SQL> column colum_name entmap on SQL> column colum_name entmap off SQL> column colum_name fold_after SQL> column colum_name fold_before SQL> column colum_name format a25 SQL> column colum_name heading header_text SQL> column colum_name justify left SQL> column colum_name justify right SQL> column colum_name justify center SQL> column colum_name like expr|alias SQL> column colum_name newline SQL> column colum_name new_value variable SQL> column colum_name print SQL> column colum_name noprint SQL> column colum_name old_value SQL> column colum_name on SQL> column colum_name off SQL> column colum_name wrapped SQL> column colum_name word_wrapped SQL> column colum_name truncated
This command can be used to make the output in SQL*Plus prettier.
format
Specifies the format for a column (that is, how the data of the column is printed).
column column_name format a20 column column_name format a50 word_wrapped column column_name format 999.999 -- Decimal sign column column_name format 999,999 -- Seperate thousands column column_name format $999 -- Include leading $ sign noprint
A column that is defined noprint will, not so strangly, not be printed at all.
|