Home » SQL & PL/SQL » SQL & PL/SQL » How to spell the numbers
How to spell the numbers [message #36713] Thu, 13 December 2001 23:15 Go to next message
Hanumantharaju
Messages: 1
Registered: December 2001
Junior Member
How to spell the numbers using dh_util package

----------------------------------------------------------------------
Re: How to spell the numbers [message #36728 is a reply to message #36713] Fri, 14 December 2001 07:00 Go to previous messageGo to next message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
look at this:
select to_char( to_date( substr( to_char(5373484),1),'j'),'Jsp') from dual

but thers is limitation , you can spell numbers only from 1 to 5373484 .

----------------------------------------------------------------------
Re: How to spell the numbers [message #36738 is a reply to message #36728] Sat, 15 December 2001 12:28 Go to previous message
sara
Messages: 36
Registered: February 2000
Member
suresh,
please explain your wonderful statement.

----------------------------------------------------------------------
Previous Topic: Get child tables.
Next Topic: Converting Views to Tables...PLEASE HELP ASAP
Goto Forum:
  


Current Time: Thu Mar 28 10:27:53 CDT 2024