Undo recovery after Big updates run for long periods followed by Kill

Here is good way mentioned the issue of rollback after session get killed and rollback initiated. http://www.dba-oracle.com/t_parallel_transaction_recovery_undo_cpu.htm.

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