Sunday, 6 March 2022
Convert Number into Words using Oracle SQL Query with PLSQL.
Convert Number into Words using Oracle SQL Query with PLSQL. Max possible number Oracle can print without any problem up to - 5373484
SQL> SELECT TO_CHAR (TO_DATE (1234567, 'j'), 'jsp') FROM DUAL;
TO_CHAR(TO_DATE(1234567,'J'),'JSP')
---------------------------------------------------------------------
one million two hundred thirty-four thousand five hundred sixty-seven
SQL> SELECT TO_CHAR (TO_DATE (9999999, 'j'), 'jsp') FROM DUAL;
SELECT TO_CHAR (TO_DATE (9999999, 'j'), 'jsp') FROM DUAL
*
ERROR at line 1:
ORA-01854: julian date must be between 1 and 5373484
SQL>
TO_CHAR(TO_DATE(5373484,'J'),'JSP')
--------------------------------------------------------------------------
five million three hundred seventy-three thousand four hundred eighty-four <== Max possible numbers.
SQL> SELECT TO_CHAR (TO_DATE (5373485, 'j'), 'jsp') FROM DUAL;
SELECT TO_CHAR (TO_DATE (5373485, 'j'), 'jsp') FROM DUAL
*
ERROR at line 1:
ORA-01854: julian date must be between 1 and 5373484
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment