Re: '' = null ?

Corey A. Harbaugh wrote at 02-Jul-00 02:36:24  on the subject Re: '' = null ?:
>nope

Of course '' is treated as NULL (Oracle 8.1.5 on Linux):

SQL> create table null_test (nn char(4) not null);

Tabelle wurde angelegt.

SQL> insert into null_test values('');
insert into null_test values('')

            *
FEHLER in Zeile 1:
ORA-01400: Einfügen von NULL in ("LA"."NULL_TEST"."NN") nicht möglich

>Norris wrote:
 

>> Is it true in Oracle that '' is equal to null value?
>>
>> For example, inserting '' value into a not null column would return error?

See above!

Hope that helps,
Lothar

-- 
Lothar Armbrüster       | lothar.armbruester_at_rheingau.vistec.net
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |