COMMAS

The COMMAS option controls the use of a character to separate thousands and millions in numeric output. COMMAS affects all commands that produce output, including the ROW command as well as HEADING, REPORT, and SHOW.

Data type

BOOLEAN

Syntax

COMMAS = {NO|YES}

Arguments

NO: Numeric output does not contain a character that separates thousands, millions, and so on.
YES: Numeric output contains a character that separates thousands, millions, and so on. (Default)

Notes

Overriding COMMAS

You can use the COMMA and NOCOMMA attributes of a HEADING, REPORT, or ROW command to override the COMMAS setting.

Setting the Thousands Separator

The character that separates thousands and millions in numeric output is normally a comma. However, it might be different depending on your NLS_TERRITORY setting. The THOUSANDSCHAR option records the character that is currently being used for separating thousands. The COMMAS option controls whether the character appears in numeric output.

Examples

Example 9-9 Showing Numerical Data Without Commas

Suppose you want to look at the cost of goods sold, without commas in the data values. You can set COMMAS to NO before producing your report.

COMMAS = NO
LIMIT line TO 'Cogs'
LIMIT month TO 'Jan96' 'Feb96'
REPORT DOWN division ACROSS month: DECIMAL 0 actual

These statements produce the following output.

LINE: COGS
               -----ACTUAL------
               ------MONTH------
DIVISION       Jan96      Feb96
-------------- -------- ----------
Camping          368044     385120
Sporting         287558     315299
Clothing         567767     610727