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.
Posted by at

1 comment:

  1. Ritesh TiwaryJuly 2, 2009 at 5:44 AM

    This query is very helpful in my project work.
    Thank you sachin

    ReplyDelete

Subscribe to: Post Comments (Atom)