Urgent Conver number to string in oracle

#1

Hi:

Anybody can tell em how i can convert like 33,000 to thirty three
thousand in oracle?

Millions thank!
Paul

#2

SQL> select to_char( to_date ( 33000 , 'J' ) , 'Jsp' ) from dual;

TO_CHAR(TO_DATE(33000
---------------------
Thirty-Three Thousand

"Paul" <jiacheng_work (AT) yahoo (DOT) com> wrote

Quote:

Hi:

Anybody can tell em how i can convert like 33,000 to thirty three
thousand in oracle?

Millions thank!
Paul

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Urgent Conver number to string in oracle

comp.databases comp.databases

Urgent Conver number to string in oracle - 12-17-2003 , 09:03 AM

Re: Urgent Conver number to string in oracle - 12-17-2003 , 02:22 PM