Format Element Description Example
$ append dollar sign at the beginning. TO_CHAR(1234,'$9999')
0 Returns leading and/or trailing zeroes. TO_CHAR(1234,'09999')
9 specified number of digits, TO_CHAR(1234,'9999')
adding leading blank space for positive numbers or
leading minus sign for negatives.
B Returns blanks for the integer of a fixed point number TO_CHAR(1234,'B9999')
C Returns ISO currency symbol. TO_CHAR(1234,'C9999')
D Returns ISO decimal character. TO_CHAR(1234.5,'99D99')
EEEE Returns value in scientific notation. TO_CHAR(1234,'9.9EEEE')
FM Returns value with no leading or trailing blank spaces. TO_CHAR(1234,'FM9999')
MI Returns negative value with the trailing minus sign; TO_CHAR(-1234,'9999MI')
positive values are returned with a trailing blank space.
PR Returns a negative value in the angle brackets, and TO_CHAR(-1234,'9999PR')
returns a positive value with leading and trailing blank spaces.
RN / rn Returns value as a Roman numeral in uppercase/or lowercase. TO_CHAR(1234,'RN')
S Appends minus or plus signs. TO_CHAR(1234,'S9999')
X Returns hexadecimal value of the specified number of digits; TO_CHAR(1234,'XXXX')
noninteger values get rounded.
--