RE: pattern search

From: Shiva Maran <Shivam_at_talisma.com>
Date: Sun, 09 Nov 2003 20:59:33 -0800
Message-ID: <F001.005D6260.20031109205933@fatcity.com>

Hi Huang/Jared,

  This is exactly what I was looking for...

Thanks
ShivaM

-----Original Message-----
Sent: Friday, November 07, 2003 7:40 PM
To: Multiple recipients of list ORACLE-L

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).

DISCLAIMER: This e-mail contains proprietary information some or all of which may be legally privileged.
It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail,
please notify the author by replying to this e-mail. If you are not the intended recipient, you must not use, 
save, disclose, distribute, copy, print or relay this e-mail.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Shiva Maran
  INET: Shivam_at_talisma.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 Sun Nov 09 2003 - 22:59:33 CST