Re: search for a number in a string?

Sorry, a senior moment.
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.
"Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
news:2687bb95.0304191533.444dcd24_at_posting.google.com...
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
 news:<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!

>
> The correct url for Tom Kyte's asktom is:  http://asktom.oracle.com
>
> The url Jim listed is some internet domain address service that will
> attempt to reset your home url!
>
> -- Mark --