RE: pattern search

From: Yong Huang <yong321_at_yahoo.com>
Date: Fri, 07 Nov 2003 06:10:08 -0800
Message-ID: <F001.005D5F8A.20031107061008@fatcity.com>

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)" <Naveen.Nahata_at_honeywell.com> wrote:
  > Not until 10g
  >
  > Regards
  > Naveen
  >
  > > -----Original Message-----
  > > From: Shiva Maran [mailto:Shivam_at_talisma.com]
  > > 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: yong321_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Fri Nov 07 2003 - 08:10:08 CST