Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> regular expressions in Perl and Oracle/SQL

regular expressions in Perl and Oracle/SQL

From: Philippe Emeriau <Philippe.Emeriau_at_infineon.com>
Date: Thu, 19 Aug 1999 17:06:35 +0200
Message-ID: <37BC1D7B.3F854DDB@infineon.com>


Hi *,

I would like to know if there is somewhere in Perl a function that computes a regular expression and gives the result stored inside a string ?
Example : the regexp is "foo[1-6]", and I would like to store the result "foo1 foo2 foo3 foo4 foo5 foo6" in a variable. Be careful , the regexp can be very more powerful, with |, &&, [, (, ... supported operators !!!

I know that Perl computes the regular expression internally, but I would like to keep the result for me, and use it to translate it in an SQL query (that's why I need the long string, that can be cut in different substrings to create the SQL query)

Thanks in advance for any help or information Cheers

Philippe

Philippe EMERIAU
Senior Software Engineer
Infineon Technologies Sophia Antipolis
Gaïa, 2600 Route des Crêtes
F-06560 Sophia Antipolis – FRANCE
WARNING : NEW EMAIL !!!
Email: Philippe.Emeriau_at_infineon.com
Tel: (+33)(0)4 92 38 37 21
Fax: (+33)(0)4 92 38 37 99 Received on Thu Aug 19 1999 - 10:06:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US