Regular expression in PL/SQL?

From: yong huang <yong321_at_yahoo.com>
Date: Tue, 28 Nov 2000 09:49:25 -0800 (PST)
Message-Id: <10694.123103@fatcity.com>

Other than the owa_pattern package from Oracle Web Server (Application Server), is there any utility in Oracle that helps me do regular expression pattern matching?

E.g, I want to insert "5068/2/" right after the "/" after "331" in "/eAsset/files/331/5068_2_image002.jpg" while "331" could be "51", "123456789", a variable length string and "5068/2/" is from the first part (ending with the second "_") of the jpg filename.

Is it possible to install the owa_pattern package without installing OAS?

While waiting for your response, I'm writing a Perl script to unload data, manipulate it and reload it.

Yong Huang
yong321_at_yahoo.com

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ Received on Tue Nov 28 2000 - 11:49:25 CST