Re: Excluding values with numbers

From: joel garry <joel-garry_at_home.com>
Date: Wed, 30 Dec 2009 09:28:47 -0800 (PST)
Message-ID: <895685f9-0295-439e-93f7-9b45e264f570_at_n38g2000yqf.googlegroups.com>

On Dec 30, 5:31 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> On Dec 29, 11:54 am, Pankaj <harpreet.n..._at_gmail.com> wrote:
>
>
>
> > Greetings,
>
> > I am currently using Oracle9i Enterprise Edition Release 9.2.0.4.0. I

>
> I agree with Joel's comments.  Let's see if there is a hard way to do
> this.
>

LOL, you should write a book! "Bad SQL! Bad, bad!"

> Something tells me you want to do it the easy way.  See if you can do
> anything with these functions:
> REGEXP_INSTRhttp://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functi...
>
> REGEXP_SUBSTRhttp://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functi...
>
> *Always* post the DDL and DML to re-create your problem, and show us
> what you have tried previously.

Watch those versions :-)

(And thanks Carlos, I should've thought of that first. TIMTOWTDI)

jg

--
_at_home.com is bogus.
http://arstechnica.com/web/news/2009/09/horrifically-bad-software-demos-become-performance-art.ars

Received on Wed Dec 30 2009 - 11:28:47 CST