To Convert Numbers into Text use the following Select Statment
select to_char(to_date(1500,'j'),'jsp') from dual
it will give you the following Result
one thousand five hundred
but you have to take in your consideration that it will not accept
more than 5,373,484
and it will cause an error
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment