i mentioned this because the programmer could make an error (use =3D =
instead
of is)
but the output is very different!
> -----Oorspronkelijk bericht-----
> Van: Koivu, Lisa [SMTP:lkoivu_at_qode.com]
> Verzonden: 9-nov-00 15:52
> Aan: 'ORACLE-L_at_fatcity.com'; 'gkor_at_rdw.nl'
> Onderwerp: RE: is null / =3D null query
>=20
> This is the correct answer, because NULL is never EQUAL to NULL.=A0 =
There
> are a few exceptions (NVL, DECODE) but=20
> the classic defition of NULL is "unknown value", therefore you can't
> determine it's value at all.=20
>=20
> I know this is theory gook, but it's the reasoning behind what you =
saw.=20
>=20
> HTH=20
>=20
> Lisa Rutland Koivu=20
> Oracle Database Administrator=20
> Qode.com=20
> 4850 North State Road 7=20
> Suite G104=20
> Fort Lauderdale, FL=A0 33319=20
>=20
> V: 954.484.3191, x174=20
> F: 954.484.2933=20
> C: 954.658.5849=20
> <http://www.qode.com>=20
>=20
> "The information contained herein does not express the opinion or =
position
> of Qode.com and cannot be attributed to or made binding upon =
Qode.com."
>=20
>=20
> -----Original Message-----=20
> From: GKor_at_rdw.nl [ <mailto:GKor_at_rdw.nl>]=20
> Sent: Thursday, November 09, 2000 9:16 AM=20
> To: Multiple recipients of list ORACLE-L=20
> Subject: is null / =3D null query=20
>=20
>=20
>=20
>=20
> Hi everyone=20
>=20
> I have launched the following query in SQL*PLUS=20
>=20
> SQL> L=20
> =A0 1* SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO =3D NULL; =
> SQL> /=20
> =A0=A0=A0=A0=A0=A0=A0=A0 0=20
>=20
> 1 row selected.=20
>=20
> SQL> SELECT COUNT(*) FROM WERK_ORDER WHERE RESULT_CODE_WO IS NULL;=20
> =A0=A0=A0=A0=A0=A0 301=20
>=20
> 1 row selected.=20
>=20
> SQL>=20
>=20
> i did'nt expect to get answer on the first query=20
>=20
> anyone with an explanation or is this a undocumented feature ?=20
>=20
> thanks=20
>=20
> gkor_at_rdw.nl=20
> rdw the netherlands=20
> --=20
> Please see the official ORACLE-L FAQ: <http://www.orafaq.com>=20
> --=20
> Author:=20
> =A0 INET: GKor_at_rdw.nl=20
>=20
> Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 FAX: (858) =
538-5051=20
> San Diego, California=A0=A0=A0=A0=A0=A0=A0 -- Public Internet access =
/ Mailing Lists=20
> --------------------------------------------------------------------=20
> To REMOVE yourself from this mailing list, send an E-Mail message=20
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in=20
> the message BODY, include a line containing: UNSUB ORACLE-L=20
> (or the name of mailing list you want to be removed from).=A0 You may =
Received on Thu Nov 09 2000 - 08:56:52 CST