OraFAQ Forum: SQL & PL/SQL » Re: HOW to convert varchar2 to NUMBER?

Home » SQL & PL/SQL » SQL & PL/SQL » Re: HOW to convert varchar2 to NUMBER?

Tue, 19 March 2002 08:48

RP
Messages: 8
Registered: January 2000

Junior Member

We have a fields called CL with type number(10). When I convert to
to_char(CL,'$9,999,990.00')) I get ora-invalid number. Please help.

Previous Topic:	result of 2sqlstts joined by query...varchar?!
Next Topic:	Oracle 8i Problem solving cases

Goto Forum:

]

Current Time: Fri Apr 19 00:28:15 CDT 2024