2019.1.8
首先建立三个表 STUDENT,SC,COURSE
CREATE TABLE "SC" (
"SNO" VARCHAR2(20),
"CNO" VARCHAR2(20),
"GRADE" VARCHAR2(20)
);
CREATE TABLE "STUDENT" (
"SNO" VARCHAR2(20),
"SNAME" VARCHAR2(20),
"SEX" VARCHAR2(20),
"DNO" VARCHAR2(20)
);
CREATE TABLE "COURSE" (
"CNO" VARCHAR2(20),
"CNAME" VARCHAR2(20),
"TNAME" VARCHAR2(20)
);
接着分别向三个表中插入数据
Insert into SC (SNO,CNO,GRADE) values ('0001','327401','70');
Insert into SC (SNO,CNO,GRADE) values ('1001','327401','80');
Insert into SC (SNO,CNO,GRADE) values ('1002','327401','90');
Insert into SC (SNO,CNO,GRADE) values ('1003','327401','85');
Insert into SC (SNO,CNO,GRADE) values ('1004','327401','87');
Insert into SC (SNO,CNO,GRADE) values ('1005','327401','86');
Insert into SC (SNO,CNO,GRADE) values ('1006','327401','56');
Insert into SC (SNO,CNO,GRADE) values ('1001','153701','85');
Insert into SC (SNO,CNO,GRADE) values ('1002','153701','60');
Insert into SC (SNO,CNO,GRADE) values ('1003','153701','70');
Insert into SC (SNO,CN