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

Home -> Community -> Usenet -> c.d.o.misc -> Re: An urgent Sql question Please help !

Re: An urgent Sql question Please help !

From: Ravinder Reddy Anumula <ranumula_at_cncx.com>
Date: 23 Oct 1998 15:38:04 PDT
Message-ID: <3631054C.6D9DF34E@cncx.com>

MUJAHID HAMID wrote:

> Dear All.
>
> I want to remove characters from a column when I select from it but keep
> numbers from it
> e.g. Table1:
> col1
> ====
> 1234
> 123a
> 12b4
> ab34
> I would like to select all the rows from this table but with characters
> filtered out.
> I like to get the following result from the query
>
> col1
> ====
> 1234
> 123
> 124
> 34
>
> and if possible just select the rows with number only and no characters in
> it.
>
> With Thanks in advance
>
> Mujahid_at_pharmco.demon.co.uk

  1. Select translate(col1,'1abcdefghijklmnopqrstuvwxyz','1') from table1.

2)select * from table1

   where to_number(col1) > 0

Try the above.

--
-Ravi. Received on Fri Oct 23 1998 - 17:38:04 CDT

Original text of this message

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