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

Home -> Community -> Usenet -> c.d.o.server -> Re: String Compare in PL/SQL

Re: String Compare in PL/SQL

From: David Schweisguth <davids_at_tracy.pangeasystems.com>
Date: 7 Oct 1998 15:22:23 GMT
Message-ID: <6vg0vf$oee$2@pornstorm.geo.net> 





hvande_at_sapient.com wrote:


: My best guess is that Oracle translates an empty string to a NULL, which is


: not the same thing.





You are correct. No, it's not the same thing. Yes, it's obnoxious. You just
have to write your code to special-case nulls.



--

Dave Schweisguth                              Work: davids_at_pangeasystems.com
Pangea Systems                                Home: dschweisguth_at_earthlink.net


Received on Wed Oct 07 1998 - 10:22:23 CDT












Original text of this message













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