Re: Need Help : SQL problem
Date: Wed, 6 Dec 2000 07:25:32 +0100
Message-ID: <90kmem$1hho4$2_at_ID-62141.news.dfncis.de>
select * from a where x is null.
RTFM question.
Regards,
Sybrand Bakker, Oracle DBA
"Adrian Ting" <adrianting_at_post1.com> wrote in message
news:90ki8c$rgs$1_at_violet.singnet.com.sg...
> Hi to all SQL gurus out there,
>
> Current facing a 'simple' SQL problem and need some help from you.
> I am using Oracle 8i Standard ed.
>
> 1) I have a table A.
> 2) I need to retrieve all records from table A which has column X being
> NULL.
> 3) Column X is a number field.
>
> I've heard that in Oracle, NULL comparisons always end up being NULL, any
> other ways to do this?
>
> Thanks.
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.215 / Virus Database: 101 - Release Date: 11/16/00
>
>
Received on Wed Dec 06 2000 - 07:25:32 CET