Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: REGEXP_SUBSTR functionality
On Sep 10, 6:00 pm, brenda.belt..._at_gmail.com wrote:
> Hi guys!!
>
> Presently working with Oracle 9.2.0.5.0 and looking for the same
> functionality that REGEXP_SUBSTR gives. Do you have any idea if
> something similar would work with the mentioned Oracle version?
>
> Thanks!
Depending on how much of the functionality you need you may be able to use a series of like operators, substr, insttr, and case statements to filter the data similar to what regexp_substr does for you.
There is also the Oracle Text product which comes with the Enterprise Edition, but you have to configure it since it is not automatically configured. You may also have to install the binary component.
Finally you can write your own function.
HTH -- Mark D Powell -- Received on Mon Sep 10 2007 - 18:48:53 CDT