Re: search for a number in a string?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Apr 2003 16:33:09 -0700
Message-ID: <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 --
Received on Sun Apr 20 2003 - 01:33:09 CEST

Original text of this message