Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> regular expressions in Perl and Oracle/SQL
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
![]() |
![]() |