Re: Regular Expression in Query or SQL

From: Makbo <makbo2_at_netscape.net>
Date: Thu, 22 Aug 2002 12:52:10 GMT
Message-ID: <3D64DE79.5030308@netscape.net>

On Metalink there is an extensive note with source code giving Oracle's solution.

Here is the header info of the note so you know what to search for.

Enjoy.

ps. Consider using a tool such as Perl w/DBI. Perl's regex abilities are awesome and with DBI, you can pretty much do whatever you need on the database side.

[ Metalink stuff ]========================== Solution: Adding Regular Expressions to Oracle Through External Procedures

Doc ID: Note:154887.1
Subject: Implementation code for the regular expressions presented in Note:119426.1 (II)

See Note:119426.1 NOTE:154880.1 for purpose of file. Program Notes

To install the package, just execute the RegularExpressionsPackage.sql script
from within a SQL*PLUS session as SYSTEM or any other user. References

Note:119426.1 NOTE:154880.1
Caution

The sample program in this article is provided for educational purposes only and is NOT supported by Oracle Support Services. It has been tested internally, however, and works as documented. We do not guarantee that it will work for you, so be sure to test it in your environment before relying on it.

==== [ end Metalink excerpt ] ====================

The C. Family wrote:

> I've searched all over Google for this, and I'm beginning to believe
> that the answer is "no, it can't be done (without inordinate effort)."
>
> I would like to use something more sophistcated than just % and _
> for pattern matching in SQL queries, and especially in check constraints.
[...]
> Is there something I have been missing in my searches and reading of
> the documentation? FWIW, I have done the research before asking the
> group. I'm hoping we aren't going down the wrong technology road for
> our app. It's the one thing that's keeping us from finalizing our RDMS
> choice on Oracle for this application. Otherwise, it's Sybase, and all
> I can say bout that is "Yikes!!!"
>
> You'd think enough people would have asked for this that the major
> RDMS vendors would just dig in an write a regex function. Sheesh.
>
Received on Thu Aug 22 2002 - 07:52:10 CDT