Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Regular Expressions in 9i
You need the owa_pattern package. You will find it in OH/rdbms/admin
IIRC.
Here are some test scripts:
http://www.cybcon.com/~jkstill/util/zips/owa_pattern_tests.tgz
Jared
"Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us>
Sent by: oracle-l-bounce_at_freelists.org
02/04/2004 09:29 AM
Please respond to oracle-l
To: oracle-l_at_freelists.org cc: Subject: Regular Expressions in 9i
All,
Anybody know the name of the packages/functions to use "Regular
Expression"
searches and replaces? This would be in 9i on Aix. I did a grep in the
rdbms/admin directory and it looks like it might be implemented in Java
code, but I don't see a PL/SQL call for them. Do I need to install Java
to
make these packages available?
PS - Jonathan - your article in the Sept./Oct. Oracle Magazine looks
great!
I'm using it as a guide!
thanks.
Tom Mercadante
Oracle Certified Professional
![]() |
![]() |