Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Regexp rant

Re: Regexp rant

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 19 Jun 2006 13:15:41 -0800
Message-ID: <449705ed$1@news.victoria.tc.ca>


snarks_at_gmail.com wrote:

: DA Morgan wrote:

: > It is unclear what it is you are trying to do that you can't do with
: > REGEXP_LIKE, REGEXP_INSTR, and REGEXP_REPLACE. Could
: > you clarify your intent.

: I'll get my coat...

???

I'm using some version of 10g database and at least in this version you simply use those functions in pl/sql code.

e.g. find the position of the last vowel in a string s

  i := regexp_instr(s,'[aeiou][^aeiou]*$'); Received on Mon Jun 19 2006 - 16:15:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US