一、第一个oracle练习
建表,外键约束。
---学生表----
create table STUDENT(
sno NUMBER(4) PRIMARY KEY,
sname VARCHAR2(10),
age NUMBER(4)
);
---班级表---
create table CLASS(
ClassId NUMBER(4) PRIMARY KEY,
cname VARCHAR2(10),
sno NUMBER(4)
);
---成绩表-----
create table GRADE(
GRANO NUMBER(4) PRIMARY KEY,
grade NUMBER(10),
sno NUMBER(4) UNIQUE
);
--建立外键关系
alter table GRADE add constraint fk_GRADE_SNO foreign key(sno) references STUDENT(sno);
--往学生表加数据
select * from STUDENT;
INSERT INTO STUDENT VALUES (1801,'mark',17);
INSERT INTO STUDENT VALUES (1802,'jack',15);
INSERT INTO STUDENT VALUES (1803,'lily',16);
INSERT INTO STUDENT VALUES (1804,'roy',15);
INSERT INTO STUDENT VALUES (1805,'karry',16);
INSERT INTO STUDENT VALUES (1806,'lay',17);
--往成绩表加数据
select * from GRADE;
INSERT INTO GRADE VALUES (11,77,1801);
INSERT INTO GRADE VALUES (12,87,1802);
INSERT INTO GRADE VALUES (13,90,1803);
INSERT INTO GRADE VALUES (14