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@xxxxxxxxxxxxxxxxxxxxxxx] Gesendet: Donnerstag, 5. Februar 2004 10:40 An: oracle-l@xxxxxxxxxxxxx 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@xxxxxx=3D20 Sent: 05 February 2004 08:59 To: oracle-l@xxxxxxxxxxxxx; Stefan.Jahnke@xxxxxx 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@xxxxxxxxxxx] 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@xxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxx 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@xxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------