Re: Simple Query

In article <3h4aml$k9a_at_peaches.cs.utexas.edu> bhala_at_cs.utexas.edu (Bhalchandra Ghatate) writes:

> Now is this a bug: ?
> junk is a table with one column of type varchar(2).
>
> ORACLE:
>
> SQL> select * from junk;
>
> NAME
> -------------------------
> 1
> 2
> 3
> 4
>
> SQL> select * from junk where name not in ('1','2','');
>
> no rows selected
>
> where are 3 and 4.

'' is equivalent to NULL. My guess is that the database is following the convention that a condition with a NULL argument returns FALSE.

• Randy

Randy Shoup
rshoup_at_oracle.com

I do not speak for Oracle Corporation.

--
Randy Shoup
Oracle Corporation
rshoup_at_oracle.com