|
--Template:
SELECT TO_CHAR(number, 'format_element')
FROM dual;
|
|
SELECT TO_CHAR(-55555, '99999S')
FROM dual;
--Result: 55555-
|
|
SELECT TO_CHAR(0, '99.99')
FROM dual;
--Result: .00
|
|
SELECT TO_CHAR(+0.5, '99.99')
FROM dual;
--Result: .50
|
|
SELECT TO_CHAR(-0.5, '99.99')
FROM dual;
--Result: -.50
|
|
SELECT TO_CHAR(+0.55, '90.99')
FROM dual;
--Result: 0.55
|
|
SELECT TO_CHAR(-0.5, '90.99')
FROM dual;
--Result: -0.50
|
|
SELECT TO_CHAR(0, '9999')
FROM dual;
--Result: 0
|
|
SELECT TO_CHAR(+222.55, '999.99')
FROM dual;
--Result: 222.55
|
|
SELECT TO_CHAR(-222.55, '999.99')
FROM dual;
--Result: -222.55
|
|
SELECT TO_CHAR(+222.55, 'FM999.09')
FROM dual;
--Result: 222.55
|
|
SELECT TO_CHAR(+555.0, 'FM999.009')
FROM dual;
--Result: 555.00
|
Oracle currency formatting examples:
|
SELECT TO_CHAR(+55.55, 'L99.99')
FROM dual;
--Result: $55.55
|
|
SELECT TO_CHAR(+55.5, 'L99.9')
FROM dual;
--Result: $55.5
|
|
SELECT TO_CHAR(100000000000, 'L99G999G999G9999', 'NLS_NUMERIC_CHARACTERS=",."')
FROM dual
--Result: $10,000,000,0000
|
|
SELECT TO_CHAR(100000000000, 'L99G999G999G9999')
FROM dual
--Result: $10.000.000.0000
|