Regexp rant
sna...@gmail.com
how do I do regexp matching in procedural code? It's enfuriating to
have a feature that is so tantalizingly close...
Phil Hibbs.
DA Morgan
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.
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
sna...@gmail.com
> 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...
Phil Hibbs.
Malcolm Dew-Jones
???
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]*$');
DA Morgan
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. ;-)
sna...@gmail.com
> : I'll get my coat...
Malcolm Dew-Jones wrote:
> ???
Er, sorry, that might not be an expression that has made it across the
pond. It's a line from a comedy programme in which someone makes a huge
blunder in a social situation, like thinking that the serious high-brow
Shakespeare conversation is all about Leonardo di Caprio's films, and
when he realises that he has blundered, gets up and says "I'll get me
coat" and leaves the group, so great is his embarrassment.
So, that was me saying "Ah, I've blundered, I can't show my face round
here any more". It turns out I've been testing these functions on a 9i
installation, which explains why they weren't working, and I assumed
that they were only available in SQL SELECT statements, not plain
variable assignment expressions.
Phil Hibbs.
DA Morgan
Thanks. Another bit of culture cross the pond.