Re: Is it possible to add a function to Oracle?

On Tue, 09 Jan 2001 21:13:29 GMT, "Scott Mattes" <ScottMattes_at_yahoo.com> wrote:

>I got to thinking about this because someone elsewheres asked about a grep
>function in Oracle (select * from table where grep( '^abc.*xyz$', field ) -
>or some such). This example can be done without regexp, but the ideal is to
>be able to use all of regular expressions to find matching data. If a
>function could be added there are plenty of regexp code that could be used
>to do it.
>
>

Yes, check out the CREATE FUNCTION/PROCEDURE command. It is in the docs under

Oracle8i SQL Reference Chapter 4 "User-Defined Functions".

Brian Received on Tue Jan 09 2001 - 17:19:40 CST