Re: AW: Regular Expressions in 9i

From: <Jared.Still_at_radisys.com>
Date: Thu, 5 Feb 2004 09:25:00 -0800
Message-ID: <OFE5BCCEDB.1A9D6284-ON88256E31.005F96ED-88256E31.005F9B6B@radisys.com>

Well, it is implemente in pure PL/SQL with lots of loops. If you want fast regex, use Perl.

And, yes of course, 10g. Coming to a desktop near you sometime in the 21st century.

Jared

Stefan Jahnke <Stefan.Jahnke_at_bov.de>
Sent by: oracle-l-bounce_at_freelists.org
02/05/2004 07:36 AM
Please respond to oracle-l

        To:     "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
        cc: 
        Subject:        AW: Regular Expressions in 9i

Oh. No offense intended. I just wanted to point out that I experienced exciting new realms of "slowness" using OWA_PATTERNS.

Stefan

-----Urspr=FCngliche Nachricht-----

Von: Niall Litchfield [mailto:n-litchfield_at_audit-commission.gov.uk] Gesendet: Donnerstag, 5. Februar 2004 10:40 An: oracle-l_at_freelists.org
Betreff: RE: Regular Expressions in 9i

Given that I submitted the owa_pattern solution tested I'm not sure I = want =3D
to point people at this but nevertheless the speed drawback is well = illustr=3D
ated here http://www.psoug.org/sql_fun.html. The problem set was to = validat=3D
e US phone numbers in as few lines of code as possible.=3D20

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=3D20

-----Original Message-----

From: Stefan.Jahnke_at_bov.de=3D20
Sent: 05 February 2004 08:59
To: oracle-l_at_freelists.org; Stefan.Jahnke_at_bov.de Subject: AW: Regular Expressions in 9i

I think Jonathan already commented on that, but I would have to add = =3D3D
that
OWA_PATTERN is horribly slow.
I wrote a package generator (generates files using UTL_FILE) using = =3D3D
patterns,
and I have to say, compared=3D3D20
to Perl regex, it's pure pain.

Stefan

-----Urspr=3D3DFCngliche Nachricht-----

Von: Jonathan Gennick [mailto:jonathan_at_gennick.com] Gesendet: Donnerstag, 5. Februar 2004 06:16 An: Mercadante, Thomas F
Betreff: Re: Regular Expressions in 9i

Wednesday, February 4, 2004, 12:29:36 PM, Mercadante, Thomas F (thomas.mercadante_at_labor.state.ny.us) wrote: MTF> PS - Jonathan - your article in the Sept./Oct. Oracle Magazine = =3D3D
looks
great!
MTF> I'm using it as a guide!

Hey, thanks for that. Good feedback is, well, always good.

Best regards,

Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@gennick.com

Join the Oracle-article list and receive one article on Oracle technologies per month by=3D3D20 email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,=3D3D20 or send email to Oracle-article-request_at_gennick.com and=3D3D20 include the word "subscribe" in either the subject or body.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

=3D3D20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or
professional privilege. Any dissemination, distribution, copyright or use of this
communication without prior permission of the sender is strictly prohibited.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

=20

Please see the official ORACLE-L FAQ: http://www.orafaq.com

Received on Thu Feb 05 2004 - 11:25:00 CST