oracle数据库学习（教师，学生，课程，成绩）实例问题之准备

 声明: 本文仅为个人总结，并非基础教程，主要通过实例问题来总结数据库sql的思想，遇到的问题以及解决方案，本人也是菜鸟，如有不足之处，还请多多指教。

首先 ，

实例数据库的建立，包括 teacher表，student表，sc表，course表，不再多说

teacher表

create table TEACHER
(
  TID   VARCHAR2(32),
  TNAME VARCHAR2(32)
)

teacher表插入数据

insert into teacher values ('001','姚明');
insert into teacher values ('002','叶平');
insert into teacher values ('003','叶开');
insert into teacher values ( '004','孟星魂');
insert into teacher values ('005','独孤求败');
insert into teacher values ('006','裘千仞');
insert into teacher values ('007','裘千尺');
insert into teacher values ('008','赵志敬');
insert into teacher values ('009','阿紫');
insert into teacher values ('010','郭芙蓉');
insert into teacher values ('011','佟湘玉');
insert into teacher values ('012','白展堂');
insert into teacher values ('013','吕轻侯');
insert into teacher values ('014','李大嘴');
insert into teacher values ('015','花无缺');
insert into teacher values ('016','金不换');
insert into teacher values ('017','乔丹');

course表 

create table COURSE
(
  CID   VARCHAR2(32),
  CNAME VARCHAR2(32),
  TID   VARCHAR2(32)
)

course表插入数据