Thursday, July 2, 2009
converting number in numeric word formate in Oracle
select to_char(to_date(&num,'Jsp'),'Jsp') from dual;
output will be one hundred twenty-three;
this statement convert the number formate in numeric word formate.
July 2, 2009 at 5:44 AM
This query is very helpful in my project work.
Thank you sachin
Post Comments (Atom)