RE: is null / = null query

Gkor,

When you want to compare null you use the clause IS NULL . Alternately, IS NOT NULL. As per your query, the second query is returning the result correctly. The first query returned zero rows because =NULL did not work.

Now, please clarify, what exactly you mean by saying that you did not expect to get answer from the first query?

Rao

Maheswara.Rao_at_SunGardP3.com

-----Original Message-----
From: GKor_at_rdw.nl [mailto:GKor_at_rdw.nl]

I have launched the following query in SQL*PLUS

SQL> L
  1* SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO = NULL; SQL> /
         0

1 row selected.

SQL> SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO IS NULL;        301

1 row selected.

SQL> i did'nt expect to get answer on the first query anyone with an explanation or is this a undocumented feature ?

thanks

gkor_at_rdw.nl Received on Thu Nov 09 2000 - 10:04:08 CST