Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Extract only numerical values for Oracle

Re: Extract only numerical values for Oracle

From: Dario Bilic <dario_at_plusplus.hr>
Date: Fri, 4 May 2001 11:04:38 +0200
Message-ID: <9ctqv1$1fu1$1@as121.tel.hr>

Hello there!

Try this query:

select * from table_name where replace(translate(field_name,'1234567890',' '),' ') is null;

Dario

"Stielmond Ng" <lkng_at_ncs.com.sg> wrote in message news:3AF2527E.AFDEF761_at_ncs.com.sg...
> 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 - 04:04:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US