Oracle学习(九)：创建和管理表(三)
no number constraint myperson_FK references dept(deptno) ON DELETE CASCADE
7 );
email varchar2(30) constraint myperson_Email uqiue,
*
第 5 行出现错误:
ORA-02253: 此处不允许约束条件说明
SQL> ed
已写入 file afiedt.buf
1 create table myperson(
2 pid varchar2(18) constraint myperson_PK primary key,
3 pname varchar2(4) constraint myperson_Name not null,
4 gender varchar2(4) constraint myperson_Gender check (gender in ('男','女')),
5 email varchar2(30) constraint myperson_Email UNIQUE,
6 deptno number constraint myperson_FK references dept(deptno) ON DELETE CASCADE
7* )
SQL>
/
表已创建。
SQL> insert into myperson values('p001','tom','男','tom@126.com',10);
已创建 1 行。
SQL> insert into myperson values('p002','tom','啊','tom123@126.com',10);
insert into myperson values('p002','tom','啊','tom123@126.com',10)
*
第 1 行出现错误:
ORA-02290: 违反检查约束条件 (SCOTT.MYPERSON_GENDER)
SQL> spool off