Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Extract only numerical values for Oracle
Hi,
Could someone shed some light on the way where I could fire an SQL
statement
to retrieve records based on a column's data of a fixed size and also
numeric?
E.g.. a column named NUMBER contains records:
1234567
234a67
34b67
I would like to retrieve only the record with '1234567'.
Thanks very much,
Stielmond NG
Received on Fri May 04 2001 - 01:55:59 CDT