Re: '' = null ?

In article <8htuuu$1epc$2_at_adenine.netfront.net>,   Norris <jcheong_at_cooper.com.hk> wrote:
> Is it true in Oracle that '' is equal to null value?
>
> For example, inserting '' value into a not null column would return
 error?
>
> --
> http://www.cooper.com.hk
>

correct
ops$tkyte_at_8i> create table t1 ( x varchar2(1) not null );

Table created.

ops$tkyte_at_8i>
ops$tkyte_at_8i> insert into t1 values ( null ); insert into t1 values ( null )

            *
ERROR at line 1:
ORA-01400: cannot insert NULL into ("OPS$TKYTE"."T1"."X")

ops$tkyte_at_8i> insert into t1 values ( '' ); insert into t1 values ( '' )

            *
ERROR at line 1:
ORA-01400: cannot insert NULL into ("OPS$TKYTE"."T1"."X")

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://osi.oracle.com/~tkyte/index.html
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.