Regular Expression Parser

From: David Fetter <dfetter_at_shell4.ba.best.com>
Date: 11 Apr 1998 19:30:43 GMT
Message-ID: <6gogd3$7ga$1@nntp1.ba.best.com>

Kind people,

Has anyone made a regular expression thingy in PL/SQL? What I'd like to do is something like

SELECT first_name, middle_name, last_name FROM disgruntled_emp_table
WHERE lname REGEX('/(sm[iy]th[e]|jones)/i') /

Has someone already made a REGEX function or something like it?

Thanks in advance for any tips, pointers or hints at which FM's I should be R'ing to make this happen.
--

            David Fetter         888 O'Farrell Street Apt E1205
   shackle_at_ren.glaci.com          San Francisco, CA 94109-7089 USA
  http://www.best.com/~dfetter     +1 415 567 2690 (voice)

print unpack ("u*",q+92G5S="!!;F]T:&5R(%!E<FP_at_2&%C:V5R"@``+)

Anyone can become angry, that is easy. But to be angry with the right person, to the right degree, at the right time, for the right purpose, and in the right way--this is not easy.

                                        Aristotle

Received on Sat Apr 11 1998 - 14:30:43 CDT