Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Simple problem...
It's me again !
One thing, scanning through char by char will not pick up valid numbers such as :
1e6 = 1,000,000
1.2345e-7 = 0.00000012345
and so on. TO_NUMBER handles all of that.
Beware !
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.comReceived on Fri Feb 28 2003 - 04:36:42 CST
-------------------------------------