SQL*Plus offers the most options when it comes to formatting numbers. Numeric format strings may contain any of the elements shown in Table B-1.
Table B-1. Numeric format elements
Causes a number to be displayed with a leading dollar sign.
Places a comma in the output.
Marks the location of the decimal point and makes it a period.
Forces zero values to be displayed as blanks.
Used at the end of a format string to cause a trailing negative sign to be displayed for negative values.
May be used at the beginning or end of a format string, and causes a sign to be displayed. The plus (+) sign is used to mark positive numbers, and the minus (-) sign marks negative numbers. When you use S, a sign is always displayed.
Causes negative values to be displayed within angle brackets. For example, -123.99 is displayed as <123.99>. Positive values are displayed with one leading and one trailing space in place of the angle brackets.
Marks the location of the decimal point. The specific character used is derived from your NLS settings.
Places a group separator (usually a comma) in the output. The specific character used is derived from your NLS settings.
Marks the place where you want the ISO currency indicator to appear. For US dollars, this is USD.
Marks the place where you want the local currency indicator to appear. For US dollars, this is the dollar sign character. You can't use L and C in the same format specification.
Used to display scaled values. ...