SQL> create table t_nbr(a number);
Table created
SQL> insert into t_nbr values(1);
1 row inserted
SQL> insert into t_nbr values('');
1 row inserted
SQL> commit;
Commit complete
SQL> commit;
Commit complete
SQL> select * from t_nbr;
A
----------
1
SQL> select a,dump(a) from t_nbr;
A DUMP(A)
---------- --------------------------------------------------------------------------------
1 Typ=2 Len=2: 193,2
NULL
SQL>
Table created
SQL> insert into t_nbr values(1);
1 row inserted
SQL> insert into t_nbr values('');
1 row inserted
SQL> commit;
Commit complete
SQL> commit;
Commit complete
SQL> select * from t_nbr;
A
----------
1
SQL> select a,dump(a) from t_nbr;
A DUMP(A)
---------- --------------------------------------------------------------------------------
1 Typ=2 Len=2: 193,2
NULL
SQL>
小结:
1,''和NULL在oracle存储皆视为NULL
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-753550/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-753550/