Fester Bestertester wrote:
> Greetings,
>
> We are using Oracle 9i. Are regexp functions available in Oracle 9i, or
> was that introduced with 10?
>
> Given the following two strings:
> str_a='5838 MISSION CENTER RD #C'
> str_b='5838 MISSION CENTER RD C'
>
> or
> str_a='7576 PARKWAY DR APT #2A'
> str_b='7576 PARKWAY DR APT 2A'
>
> is it possible to write an expression in Oracle 9i that will return true
> if the only difference between the two strings is the presence of the
> '#' symbol?
Regular expressions have been available since version 8 in the
OWA_PATTERN package.
http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/w_patt.htm#i999925
Not nearly as fast or robust as the 10g implementation but they are there.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Oct 22 2007 - 15:24:39 CDT
