9i
参照
ALTER TABLE HASH_PRODUCTS ADD (
CONSTRAINT PRODUCT_STATUS_LOV CHECK (product_status in ('orderable'
,'planned'
,'under development'
,'obsolete')
));
参照
ALTER TABLE HASH_PRODUCTS ADD (
CONSTRAINT PRODUCT_STATUS_LOV CHECK (product_status in ('orderable'
,'planned'
,'under development'
,'obsolete')
));
alter table A add check ( col1 in (1,2,3,4))
enable novalidate;//因為表中已有数据,不会对已有数据进行检查,只对增加或修改的记录才作检查.
回复人: yangqingdelphi() ( ) 信誉:100 2004-9-2 10:18:37 得分: 0
9i
参照
ALTER TABLE HASH_PRODUCTS ADD (
CONSTRAINT PRODUCT_STATUS_LOV CHECK (product_status in ('orderable'
,'planned'
,'under development'
,'obsolete')
));
给约束起一个名字,这样便于维护
SQL> create table test1(
2 id number)
3 tablespace users;表已创建。SQL> alter table test1 add check (id in (1,2,33,44));表已更改。SQL> insert into test1 values(4);
insert into test1 values(4)
*
ERROR at line 1:
ORA-02290: check constraint (SYS.SYS_C00866) violated
SQL>