Re: Regular Expressions in PL/SQL?
From: Simon Taylor <simon_at_unisolve.com.au>
Date: 1997/05/05
Message-ID: <01bc59aa$49d15820$a54a05cb_at_simon.iaccess.com.au>#1/1
Date: 1997/05/05
Message-ID: <01bc59aa$49d15820$a54a05cb_at_simon.iaccess.com.au>#1/1
Joe,
I know of a very comprehensive set of PL/SQL procedures and functions
written by David Bath of Global Consulting here in Melbourne, they
emulate many of the standard "c" library string function calls, and lots
more besides. *However* handling regular expressions is one thing they
don't do. I think it's fair to say that programmatically handling
unix-style
regular expressions requires the ability to allocate memory as required
whilst parsing the regexp, and that PL/SQL is not (as far as I'm aware)
equipped to do dynamic memory allocation/deallocation.
Handling regexps in the Unix regcmp() and regexp() style would be a great extension to PL/SQL, does anyone from Oracle have a comment on this?
-- Simon Taylor Unisolve Pty Ltd Melbourne, Australia Joe O'Connor <joe_at_exit109.com> wrote in article <336C0CCE.B6637807_at_exit109.com>...Received on Mon May 05 1997 - 00:00:00 CEST
>
> I am new to PL/SQL programming. Ther looks like there is no native
> support for regular expressions in PL/SQL.
>
> Does anyone know of any third party PL/SQL libraries that will allow me
> to perform string manipulation using regular expression is PL/SQL?
>
> Thanx
> -- Joe
>
>