ORACLE

Number to word and word to number value print in oracle

Print Value
NUMBER TO WORD -----QUERY is for oracle

1
st hardcodeSELECT to_char(to_date('100','j'),'jsp') FROM dual2nd DYNAMIC WAYSELECT
to_char(to_date('&a','j'),'jsp') FROM dual
                     RESULT ONE HUNDRED
Print value
WORD
TO NUMBER------ QUERY is for oracle

SELECT LEVELFROM
dualWHERE to_char(to_date(LEVEL,'J'), 'JSP') = 'ONE HUNDRED'CONNECT BY to_char(to_date(LEVEL-1,'J'), 'JSP') != 'ONE HUNDRED'AND LEVEL < 10001;
          Result 100