Question

SQL 错误: ORA-00001: 违反唯一约束条件 (ZHANGHUA.SYS_C007301)

create table Student
( SNO char(5) primary key,
SNAME varchar2(20) not null,
SDEPT char(2) not null,
SCLASS char(2) not null,
SSEX char(3),
SAGE number(2,0)
);
insert into Student values('96001','马小燕','CS','01','女',21);
insert into Student values('96002','黎明','CS','01','男',18);
insert into Student values('96003','刘东明','MA','01','男',18);
insert into Student values('96004','赵志勇','IS','02','男',20);
insert into Student values('97001','马蓉','MA','02','女',19);
insert into Student values('97002','李成功','CS','01','男',20);
insert into Student values('97003','黎明','IS','03','女',19);
insert into Student values('97004','李丽','CS','02','女',19);
insert into Student values('96005','司马志明','CS','02','男',18);
commit;

Answer 1

把主键设置成序列。或者保证他的唯一性，如果不行就设置联合主键。或者干脆就不设置主键，但是会造成数据冗余。

追问

不懂。。。要怎么搞啊