Re: Regular expressions?

I haven't done it, but I would think you could do it via some Java stored procedures. There are several (one from GNU?) regex classes for Java in general, and I would think you could load those classes into the Oracle JVM and write a stored procedure to take advantage of those classes for ad-hoc regex things. No?

Mike

Steve Wilbur wrote in message <020520010947302457%ultramafic1_at_yahoo.com>...
>Is there a way to use regular exrpessions with oracle? In particular,
>I'm seeking a function something like:
>
>REGEX(ARG1,ARG2)
>
>where ARG1 is the regular expression and ARG2 is the value of interest.
>For example:
>
>select * from employee where REGEX("\d\d$,somecolumn);
>
>would select all records where the value for somecolumn ends with two
>digits. in this case, the regex is pretty simple and you could
>probably use LIKE, but there are plenty for which LIKE will not work,
>and those are the ones I am interested in.
>
>select * from townships
> where not REGEX("^[FUCKS]\d{1,3}[NS]\d{1,3}[EW]$",mtr);
>
>is one i would use a lot if i could.
>
>As it is now, I'm using PERL with DBI to do my queries and doing my
>regular expression matching in perl.
>
>Thanks in advance (:
Received on Wed May 02 2001 - 22:48:14 CDT