.Net Developer
Thursday, July 2, 2009
converting number in numeric word formate in Oracle
select to_char(to_date(&num,'Jsp'),'Jsp') from dual;
num=123;
output will be one hundred twenty-three;
this statement convert the number formate in numeric word formate.
Newer Posts
Home
Subscribe to:
Posts (Atom)