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@(protected)>
Sent by: oracle-l-bounce@(protected)
02/05/2004 07:36 AM
Please respond to oracle-l
To: "'oracle-l@(protected)>
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@(protected)]
Gesendet: Donnerstag, 5. Februar 2004 10:40
An: oracle-l@(protected)
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@(protected)
Sent: 05 February 2004 08:59
To: oracle-l@(protected)
Subject: AW: Regular Expressions in 9i
Hi
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@(protected)]
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@(protected):
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@(protected)
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@(protected)
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@(protected)
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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
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
-----------------------------------------------------------------
**********************************************************************
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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
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
-----------------------------------------------------------------
=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
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
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
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
-----------------------------------------------------------------
