Naveen and Shiva, Please see my article at http://www.stormloader.com/yonghuang/computer/OracleRegExp.html for a summary of the usage of owa_pattern, a very little known package since probably Oracle 7.3. It also has a link to Tom Kyte, Mark Piermarini and Daniel Savarese's external Java approach, as well as Jonathan Gennick's article on 10g regular expressions.
Yong Huang --- "Naveen, Nahata (IE10)" <[EMAIL PROTECTED]> wrote: > Not until 10g > > Regards > Naveen > > > -----Original Message----- > > From: Shiva Maran [mailto:[EMAIL PROTECTED] > > Sent: Friday, November 07, 2003 12:50 PM > > To: Multiple recipients of list ORACLE-L > > Subject: pattern search > > > > > > Hi All, > > > > I need a means to search for a pattern (With basic wildcard > > characters like %, _, ^, []). How do I do this in oracle. I > > also need to get back the string that matches the pattern. Is > > there any predefined function or procedure that does this. > > Would like to avoid implementing this on my own. > > > > TIA, > > ShivaM __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
