Re: Question about Oracle compatibility

Mario Weilguni writes:> This gets really bad when the actual data is coming from a> webinterface, I've to handle 2
differentqueries for the case empty> string and non-empty string.
 

In their documentation both Oracle 7 and 8 state:
   Oracle currently treats a character value with a length of zero   as null.  However, this may not continue to be
truein future   releases, and Oracle recommends that you do not treat empty   strings the same as NULLs.
 

-- 
Pete Forman                 -./\.- Disclaimer: This post is originated
Western Geophysical           -./\.-  by myself and does not represent
pete.forman@westgeo.com         -./\.-  the opinion of Baker Hughes or
http://www.crosswinds.net/~petef  -./\.-  its divisions.