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.