Re: Easy SQL problem

Ben wrote:

> Any one know if this is a new 9i feature or not?
>
> I have the following table.
>
> SQL> desc table1
> Name Null? Type
> ----------------------------------------------------- --------
> -----------
> ID
> VARCHAR2(5)
> NAME
> VARCHAR2(5)
>
> SQL> insert into table1 values ('242','');
>
> 1 row created.
>
> SQL> select * from table1;
>
> ID NAME
> ----- ------------------------------
> 1 A
> 2 A
> 3 C
> 4 D
> 5. E
> aaa C
> 242
>
> 7 rows selected.
>
> SQL> select * from table1 where name is null;
>
> ID NAME
> ----- ------------------------------
> 242
>
> SQL> select * from table1 where name is not null;
>
> ID NAME
> ----- ------------------------------
> 1 A
> 2 A
> 3 C
> 4 D
> 5. E
> aaa C
>
> 6 rows selected.
>
> SQL> select * from table1 where name <> '';
>
> no rows selected
>
> SQL> select * from table1 where name = '';
>
> no rows selected
>
> My question is why do I get no rows selected for "select * from table1
> where name <> '';" and "select * from table1 where name = '';"?
>
> Any idea?
>
> Thanks!!
> Ben

What makes you think that '' is NULL?

Hopefully nothing but a brief memory lapse.

Your insert statement should have been:

insert into table1 values ('242', NULL);

Daniel Morgan Received on Sun Aug 11 2002 - 09:10:18 CDT