structure of table:create table TEST_TABLE
(
A VARCHAR2(32) not null,
B CHAR(1) default 'N' not null,
C CHAR(1) default 'N' not null
)when i excute below script encounter error!
insert into TEST_TABLE values('######',null,null);ORA-01400 can not insert NULL to TEST_TABLE.Bdo anyone can tell me why?thanks!
(
A VARCHAR2(32) not null,
B CHAR(1) default 'N' not null,
C CHAR(1) default 'N' not null
)when i excute below script encounter error!
insert into TEST_TABLE values('######',null,null);ORA-01400 can not insert NULL to TEST_TABLE.Bdo anyone can tell me why?thanks!
没有赋值的变量 相当于c++中定义没有赋值的指针
(
A VARCHAR2(32) not null,
B CHAR(1) default 'N' not null,
C CHAR(1) default 'N' not null
) but i have default value here.
when insert into table NULL will be replaced by 'N'???
what was the constraint to work .