Re: is null / = null query

From: Arul kumar <rakumar_at_mahindrabt.com>
Date: Fri, 10 Nov 2000 12:31:11 +0530
Message-Id: <10675.121685@fatcity.com>

--------------21553C3EEAF834419EED49BB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

Rewrite the query as:

SELECT COUNT(*) FROM WERK_ORDER WHERE
RESULT_CODE_WO IS NULL; Arul.

> Hi everyone

> >
> > 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
> > rdw the netherlands

--------------21553C3EEAF834419EED49BB
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en"> <html>
Hi,

<p>Rewrite the query as:
<p>SELECT COUNT(*) FROM WERK_ORDER WHERE
<br>RESULT_CODE_WO <font color="#3333FF">IS</font> NULL;
<p>Arul.
<p>> Hi everyone
<blockquote TYPE=CITE>>
<br>> I have launched the following query in SQL*PLUS
<br>>
<br>> SQL> L
<br>>&nbsp;&nbsp; 1* SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO

= NULL;

<br>> SQL> /
<br>>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0
<br>>
<br>> 1 row selected.
<br>>
<br>> SQL> SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO IS NULL;
<br>>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 301
<br>>
<br>> 1 row selected.
<br>>
<br>> SQL>
<br>>
<br>> i did'nt expect to get answer on the first query
<br>>
<br>> anyone with an explanation or is this a undocumented feature ?
<br>>
<br>> thanks
<br>>
<br>> gkor_at_rdw.nl
<br>> rdw the netherlands</blockquote>

Received on Fri Nov 10 2000 - 01:01:11 CST