Re: search for a number in a string?
From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Sat, 19 Apr 2003 13:07:34 GMT
Message-ID: <pSboa.286135$Zo.56819_at_sccrnsc03>
Date: Sat, 19 Apr 2003 13:07:34 GMT
Message-ID: <pSboa.286135$Zo.56819_at_sccrnsc03>
Go to www.oracle.asktom.com and look up regular expressions. (that's one
method)
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"Geetha" <gelangov_at_hotmail.com> wrote in message
news:4b40e20a.0304190448.107c5537_at_posting.google.com...
>
> In oracle, is there a way to search for a number in a string?
> For example, in SQL server we can do:
> select * from sysobjects where name like 'df_arc%[0-9]':
> DF_Arc__1
> DF_Arc__10
> DF_Arc__11
> DF_Arc__12
> DF_Arc__13
> DF_Arc__14
> DF_Arc__15
> DF_Arc__16
> DF_Arc__17
> ...
>
> Thank you very much for your help in advance!
Received on Sat Apr 19 2003 - 15:07:34 CEST