Oracle column commands
The Oracle column command can be used to format the column title and data. The syntax of this command is as follows:
COL [UMN] [{column | expr} [option...]
Column name
Options specifies one or more options used to format columns or aliases.
The option options are as follows:
ALI [AS] alias specifies the alias of the column to be formatted
CLE [AR] Clear column formatting
ENTMAP {ON | OFF}
FOLD_A [FTER]
FOLD_ B [EFORE]
FOR [MAT] format: Set the display format of columns or columns to the format specified by the format string.
HEA [DING] text sets the column title specified by the text string
JUS [align] {L [EFT] | C [ENTER] | R [IGHT]} sets the output information of the column to the left alignment, and either the right or the right alignment of the curve
LIKE {expr | alias}
NEWL [INE]
NEW_V [ALUE] variable
NOPRI [NT] | PRI [NT] Hide the column title
Content displayed when the NUL [L] text column is null
OLD_V [ALUE] variable
ON | OFF
WRA [PPED] | WOR [D_WRAPPED] | TRU [NCATED] displays a line break at the end of a string in the output result. This option may cause the word to span multiple rows.
Format element:
An: Set the width of the column content of the varchar type. If the content exceeds the specified width, the content will be automatically wrapped. For example: A10
9: Set the actual format of the number column, for example: 999 999
$: Floating currency symbol. Example: $99
L: local currency symbol. Example: L99
.: Decimal point. Example: 9999.9
,: 9,999 delimiter