Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Need Help : SQL problem

Need Help : SQL problem

From: Adrian Ting <adrianting_at_post1.com>
Date: Wed, 6 Dec 2000 13:24:29 +0800
Message-ID: <90ki8c$rgs$1@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 Tue Dec 05 2000 - 23:24:29 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US