June 13, 2011

Best way to convert number into words in oracle


Best way to convert number into words in oracle


Select to_char(to_date(232321,'J'), 'JSP') words from dual;


JSP- Julian Spelling which converts the numbers to words.

No comments:

Post a Comment