Re: Is this stuff really SQL 92 compliant

Jim Hill - MVS SQL*Net (jthill_at_upsizeme.us.oracle.com.) wrote:
: value, and the value of C1 is unknown. 'NULL' should imvho have been
: 'unknown' If you want to treat 'unknown' as 'irrelevant', use NVL to
: lowball it, e.g.

Jim, you must have been taking some Oracle's SQL Course.

Oracle's NULL Rule #1 says that, whenever someone uses any other than 'NOT NULL' column name, one should use NVL. Otherwise there is no way of knowing how different Oracle operations behave with it, since the interpretation is different each time.

This, of course, is the easy way to save Oracle and move the pain to us.

Regards,

        Hessu

-- 
---------------------------------------------------------------------
Heikki Rissanen, United Papermills, Rauma, Finland
Email: heikki.rissanen_at_ra.upm.yhtyneet.mailnet.fi
---------------------------------------------------------------------