Re: Excluding values with numbers

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Wed, 30 Dec 2009 13:49:40 -0800 (PST)
Message-ID: <8c45e8d0-405f-4fad-9d18-6a0ccf5485e8_at_n38g2000yqf.googlegroups.com>

On Dec 30, 12:28 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Dec 30, 5:31 am, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> 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

That would be an interesting title for a book. Take a somewhat simple request and see how many different (or overly complex) solutions may be generated for the request.

More specifically on your second point, regular expressions are not available in Oracle 9i R2 - for some reason I thought that they were introduced with Oracle 9i R1 (I even performed a search to verify - I should have clicked one of the links). After seeing your post, I searched again and found a couple interesting articles for those people running Oracle 10g R1 and above:
http://download.oracle.com/owsf_2003/40105_Gennick_04.ppt http://download.oracle.com/owsf_2003/40105.doc

Charles Hooper
Co-author of "Expert Oracle Practices: Oracle Database Administration from the Oak Table"
http://hoopercharles.wordpress.com/
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Wed Dec 30 2009 - 15:49:40 CST