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

Home -> Community -> Usenet -> c.d.o.server -> Re: No value

Re: No value

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Wed, 8 Dec 1999 09:57:53 +0900
Message-ID: <G3i34.2513$sI3.88882@news.hananet.net>

Bulent Gumus <bgumus_at_onboard-software.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:82k5jn$2o3$1_at_nnrp1.deja.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> I have a table and in one column there are two discrete values "A" or
> "D". but some rows does not have any value. and when I say
>
> select *
> from table
> where type not like 'D' and type not like 'A'
>
> it gives "0 rows selected".
>
> So what should I do to get the rows with no value in type column?
>
> Thanks in advance,
>
> --
> Software Engineer
> OnBoard Software Inc.
> Kelly AFB, Texas
> http://www.onboard-software.com/
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Select *
from table
where type is null;

or

select *
from table
where type not in ('A','D'); Received on Tue Dec 07 1999 - 18:57:53 CST

Original text of this message

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