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: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 19 Jun 2006 15:02:10 -0700
Message-ID: <1150754533.808636@bubbleator.drizzle.com>


Malcolm Dew-Jones wrote:
> 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]*$');

And what is it precisely you are trying to do that can not be done with the current tool set? It is extremely hard to help you if you can't be specific and provide an example.

.. snarks ... get your hat too. This may take awhile. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Jun 19 2006 - 17:02:10 CDT

Original text of this message

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