[Oracle 8] Null et '' dans une requete

Article View: comp.databases.oracle.misc

Article #79

Back to comp.databases.oracle.misc Previous Next

#79

From: Olivier Utkala
Date: Wed, 14 Jun 2000 00:00

11 lines
1435 bytes

Suite � des requ�tes sur un table comportant un colonne "nullable", une
diff�rence � �t� observ�e quand au r�sultat de deux requ�tes :

select * from table where col = '' -- requete qui ne retourne rien !
et
select * from table where col IS NULL -- qui r�pond au r�sultat attendu.

Y-a-t'il un param�tre de l'instance � modifier afin d'avoir un r�sultat
identique pour les requ�tes ?
Ceci permettrait d'avoir un code SQL identique pour les SGBD d'�diteurs
diff�rents.

Technical Details

Message-ID: <8i823i$cbi$1@s2.feed.news.oleane.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: FRENCH,ASCII
X-Google-Thread: ffbfc,c3c36c89b8694424,start
X-Google-Attributes: gidffbfc,public
X-Google-Thread: f99a8,c3c36c89b8694424,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: fa4f9,c3c36c89b8694424,start
X-Google-Attributes: gidfa4f9,public
From: "Olivier Utkala" <olivier.utkala@msg-software.com>
Subject: [Oracle 8] Null et '' dans une requete
Date: 2000/06/14
Message-ID: <8i823i$cbi$1@s2.feed.news.oleane.net>
X-Deja-AN: 634423188
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
X-Complaints-To: abuse@oleane.net
X-Trace: s2.feed.news.oleane.net 960990131 12658 62.161.35.26 (14 Jun 2000 13:42:11 GMT)
Organization: Guest of France Telecom Oleane's newsreading service
X-MSMail-Priority: Normal
NNTP-Posting-Date: 14 Jun 2000 13:42:11 GMT
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,fr.comp.applications.sgbd