Re: [Oracle 8] Null et '' dans une requete

Article View: comp.databases.oracle.misc

Article #78

Back to comp.databases.oracle.misc Previous Next

#78

From: Patrick Texier
Date: Wed, 14 Jun 2000 00:00

17 lines
1609 bytes

[fu2 fr.comp.applications.sgbb french speaking group. Do *not* crosspost
between fr. et comp. groups - Sorry for comp.* users]

Le Wed, 14 Jun 2000 15:41:04 +0200, "Olivier Utkala"
<olivier.utkala@msg-software.com> a �crit :

> 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.

C'est la m�me chose pour tous les SGBB, la valeur chaine vide est
diff�rente de la valeur nulle. Soit vous testez pr�cis�ment les entr�es
dans la base, soit vous testez les deux valeurs en sortie.

-- 
Patrick Texier
http://www.genindre.org

Technical Details

Message-ID: <8i8a6u.3vvc4k1.1@pt.genindre.org>

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

References: <8i823i$cbi$1@s2.feed.news.oleane.net>

Show Full Headers

Complete Article Headers

X-Google-Language: FRENCH,ASCII
X-Google-Thread: ffbfc,c3c36c89b8694424
X-Google-Attributes: gidffbfc,public
X-Google-Thread: fa4f9,c3c36c89b8694424
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f99a8,c3c36c89b8694424
X-Google-Attributes: gidf99a8,public
From: Patrick Texier <p.texier@genindre.org>
Subject: Re: [Oracle 8] Null et '' dans une requete
Date: 2000/06/14
Message-ID: <8i8a6u.3vvc4k1.1@pt.genindre.org>
X-Deja-AN: 634461437
Content-Transfer-Encoding: 8bit
References: <8i823i$cbi$1@s2.feed.news.oleane.net>
X-Posting-Agent: Hamster/1.3.18.0
Content-Type: text/plain; charset=ISO-8859-1
X-Complaints-To: abuse@proxad.net
X-Trace: nnrp4.proxad.net 960994106 212.23.166.61 (Wed, 14 Jun 2000 16:48:26 CEST)
Organization: parfaite, je ne melange rien :-)
MIME-Version: 1.0
NNTP-Posting-Date: Wed, 14 Jun 2000 16:48:26 CEST
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,fr.comp.applications.sgbd

Reply to Parent Message