创建表时default默认值不起作用

[size=medium]create table HOUSEHOLDSTAFFS
(
ID NUMBER(10) not null,
IDCARDNO VARCHAR2(60) not null,
NAME VARCHAR2(60) not null,
[color=red] LOGOUT NUMBER(1) default 0 ,[/color]
……
constraint PK_HOUSEHOLDSTAFFS_ID primary key (ID),
constraint FK_CENSUSREGISTER_FAMILYID foreign key (FAMILYID)
);

comment on column HOUSEHOLDSTAFFS.IDCARDNO
is '身份证号';
comment on column HOUSEHOLDSTAFFS.NAME
is '姓名';
comment on column HOUSEHOLDSTAFFS.USEDNAME
is '曾用名';
comment on column HOUSEHOLDSTAFFS.LOGOUT
is '是否注销 0否 1是';

……

增进去一条数据,不对logOut做任何设置（即添加进去的数据logOut=null），发现default 0 并没有起作用，logOut是null。

[img]http://dl.iteye.com/upload/attachment/0072/7345/9ad6e208-3b9c-31a8-9de1-ff5af9b2f069.jpg[/img]


将创建表的语句改为如下就ok了

create table HOUSEHOLDSTAFFS
(
ID NUMBER(10) not null,
IDCARDNO VARCHAR2(60) not null,
NAME VARCHAR2(60) not null,
[color=red] LOGOUT NUMBER(1) default 0 not null,[/color]
……
constraint PK_HOUSEHOLDSTAFFS_ID primary key (ID),
constraint FK_CENSUSREGISTER_FAMILYID foreign key (FAMILYID)
);
…………

再次添加一条数据，不对logOut做任何设置（即添加进去的数据logOut=null），查询结果，发现logOut会生成默认值0

[img]http://dl.iteye.com/upload/attachment/0072/7360/5e733c38-3338-3d4a-b6cd-2bbe8a5fbe97.jpg[/img][/size]