Re: Inserting surname of Null from a subquery results in a NULL value

From: <ak_tiredofspam_at_yahoo.com>
Date: 10 Dec 2004 09:04:39 -0800
Message-ID: <1102698279.429935.260760@c13g2000cwb.googlegroups.com>

I don't see the problem:

CREATE TABLE a(n VARCHAR2(30))
Table created

INSERT INTO a VALUES('Null')
1 row inserted

SELECT N,
CASE WHEN n IS NULL THEN 'n IS NULL' ELSE 'n IS NOT NULL' END IS_NULL FROM a

N                              IS_NULL
------------------------------ -------------
Null                           n IS NOT NULL

1 row selected    

DROP TABLE a
Table dropped Received on Fri Dec 10 2004 - 11:04:39 CST