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!
解决方案 »
- oracle 把net manager快捷方式删怎么办!
- ORA-01940: cannot drop a user that is currently connected 错误
- 生僻字字符集问题
- 如果你是面试官……
- oracle安全的问题
- sql*plus连接远程数据库,主机字符串怎么写?
- sybase-->oracle数据库移植
- hpunix11上装oracle817时遇到困难,请高手帮忙
- 一个简单的oracle建表问题
- org.hibernate.QueryParameterException: could not locate parameter [payStatus]
- 关于当前表与历史表的备份的问题,大家来看看...
- 数值类字段没有值的时候留NULL好还是写0好
没有赋值的变量 相当于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 .