Couple of notes:
- No Oracle version. In 9i, you can use ANSI JOIN syntax the same
way you do in mssql (that is, use LEFT JOIN instead of those (+)
thingies.) With 8i - you have to live with them and the fact that certain
joins are not possible with this syntax. 9.2 with the latest patch set
applied is recommended though - there were numerous bugs with
ANSI joins in 9.0.1 and initial 9.2 releases ranging from security
holes to wrong results.
- Use NVL() instead of IsNull().
- Empty strings are NULLs in Oracle, so NVL(acolumn,'') will result in
NULL if acolumn is NULL - not what you actually want. You gotta add
AND (acolumn IS NOT NULL) condition for each column where you
expect NULLs but compare to a constant - you can't compare NULLs
to anything.
That's actually three notes. :) Corrections and additions welcome.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
Received on Wed Mar 19 2003 - 04:19:52 CST
