This is version 1 2 3 4 5 6 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

ORACLE NUMBER FORMAT MODELS for TO_CHAR#

This table lists the number format elements. You can use any combination of these elements as the format argument of the TO_CHAR function.

Parameter	Example	Explanation
9	‘9999’	Number of “9”s determines the length of the returned character
0	‘0999’	Prefixes value with leading zeroes
$	‘$9999’	Prefixes value with a dollar sign
B	‘B9999’	Returns zero value as a blank, instead of as 0
MI	‘9999MI’	Returns ‘-‘ after negative values. Note that by default, a space is left in front of any number value converted to character, to allow for the possibility of a negative sign.
S	‘S9999’	Returns ‘+’ for positive values and ‘-‘ for negative values.
PR	‘9999PR’	Returns negative values in <angle brackets>.
,	‘9,999’	Returns a comma in this position (Thousands separator)
.	’99.99’	Returns a period in this position. (Decimal point)
V or v	‘999V99’	Returns the value by 10n where n is the number of “9”s after the “V” (implied decimal point)
RN or rn	RN	Upper or lowercase Roman numerals (for integers in range 1 ..3999)