Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> String Comparisons in Oracle 9i

String Comparisons in Oracle 9i

From: Fester Bestertester <whatmeworry_at_mad.net>
Date: Mon, 22 Oct 2007 11:36:56 -0700
Message-ID: <ffiqim$pa8$1@gondor.sdsu.edu> 





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?
Received on Mon Oct 22 2007 - 13:36:56 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US