Wiki: NUMBER FORMAT MODELS (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)

Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor