Re: newbie: conditions in expressions

From: Jurij Modic <jmodic_at_src.si>
Date: Fri, 05 Feb 1999 16:29:20 GMT
Message-ID: <36bb180f.13002798@news.siol.net>

On Fri, 05 Feb 1999 12:19:50 GMT, rosinowski_at_gmx.de (Jan Rosinowski) wrote:

>>Hope this helps.
>
>it does! thanks a lot!
>
>do you also know of an easy test for IS NULL of LONG RAWs? decode
>doesn't accept them

Ther is no problem with IS NULL checking, since DECODE is the only contruct where two NULL values are treated as equal. So the expresion for "x IS NULL" checking is:

DECODE (x, NULL, 1, -1)

where 1 means TRUE, -1 means FALSE

>ciao, jan

HTH,
Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Fri Feb 05 1999 - 10:29:20 CST