Oracle column commands

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.