Technology

Oracle Number Format

admin 2020.09.27 19:59 Views : 77

 
Oracle PL/SQL

			1
2
3
4

			--Template:
 
SELECT TO_CHAR(number, 'format_element')
  FROM dual;

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(-55555, '99999S')
  FROM dual;
 
--Result: 55555-

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(0, '99.99')
  FROM dual;
 
--Result: .00

 
Oracle PL/SQL

			1
2
3

			SELECT TO_CHAR(+0.5, '99.99')
  FROM dual;
--Result: .50

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(-0.5, '99.99')
  FROM dual;
 
--Result: -.50

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(+0.55, '90.99')
  FROM dual;
 
--Result: 0.55

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(-0.5, '90.99')
  FROM dual;
 
--Result: -0.50

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(0, '9999')
  FROM dual;
 
--Result: 0

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(+222.55, '999.99')
  FROM dual;
 
--Result: 222.55

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(-222.55, '999.99')
  FROM dual;
 
--Result: -222.55

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(+222.55, 'FM999.09')
  FROM dual;
 
--Result: 222.55

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(+555.0, 'FM999.009')
  FROM dual;
 
--Result: 555.00

Oracle currency formatting examples:

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(+55.55, 'L99.99')
  FROM dual;
 
--Result: $55.55

 
Oracle PL/SQL

			1
2
3
4

			SELECT TO_CHAR(+55.5, 'L99.9')
  FROM dual;
 
--Result: $55.5

 
Oracle PL/SQL

			1
2
3
4

			SELECT  TO_CHAR(100000000000, 'L99G999G999G9999', 'NLS_NUMERIC_CHARACTERS=",."')
FROM dual
 
--Result: $10,000,000,0000

 
Oracle PL/SQL

			1
2
3
4

			SELECT  TO_CHAR(100000000000, 'L99G999G999G9999')
FROM dual  
 
--Result: $10.000.000.0000

I want to

List

Comment 0

No.	Subject
Notice	Certification Oracle SQL Developer
154	TECH on the Net
153	trim(to_char(:P113_REGULAR,'999G999G999G999G990D00'))
152	PIVOT
151	TEST 2
150	CREATION DEDUCTION TYPE
149	PL/SQL for creation Tables
148	TEST 1
147	INNER JOIN & GROUP BY
146	DISPLAY ONLY FEW ROWS
145	GROUP BY (for CHART)
144	INNER JOIN
143	LOOP - 2
142	DATE Compare & Convert
141	LOOP & ROWNUM
»	Oracle Number Format
139	Page Reload in APEX
138	SUM / GROUP BY
137	MEDWIGS DB
136	HOW TO CONVERT DD/MM/YYYY -> MM/DD/YYYY
135	Attributes - Link Icon

Write Tag

First Page 1 2 3 4 5 6 7 8 9 10 Last Page