SQL> alter table info add constraint ck_info_gender 2 check(stu_sex='男' or stu_sex='女'); 1. 2. 3、解决办法 是由于check这个函数不存在,即使在里面输入了参数,也会报错;所以,添加check函数
SQL> alter table t1 add (number number); alter table t1 add (number number) * ERROR at line 1: ORA-00904: : invalid identifier SQL> alter table t1 add ("NUMBER" number); Table altered. SQL> desc t1 Name Null? Type --- --- --- C1 NUMBER NUMBER NUMBER SQL> select number from ...