Oracle学生信息建表与导入数据_oracle建学生表-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_39400984/article/details/100150244

本文详细介绍了使用Oracle数据库创建学生选课系统的过程，包括学生、课程及选课信息的表结构设计，数据插入及基本查询操作。通过具体的SQL语句，展示了如何实现学生信息、课程信息及选课记录的管理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

create table student(
  sno varchar2(20) primary key,
  sname varchar2(20) not null,
  ssex varchar2(20) not null,
  sage number(5) not null,
  sdep varchar2(20) not null,
  screate date default sysdate
);
comment on table student is '学生信息';
comment on column student.sno is '学号';
comment on column student.sname is '姓名';
comment on column student.ssex is '性别';
comment on column student.sage is '年龄';
comment on column student.sdep is '院系';
comment on column student.screate is '入学时间';

insert all into student(sno, sname, sage, ssex, sdep) values('10001','李白',21,'男','AS')
into student(sno, sname, sage, ssex, sdep) values('10002','大乔',22,'女','BS')
into student(sno, sname, sage, ssex, sdep) values('10003','马超',18,'男','AS')
into student(sno, sname, sage, ssex, sdep) values('10004','花木兰',17,'女','BS')
into student(sno, sname, sage, ssex, sdep) values('10005','狄仁杰',19,'男','CS')
into student(sno, sname, sage, ssex, sdep) values('10006','貂蝉',15,'女','CS')
into student(sno, sname, sage, ssex, sdep) values('10007','孙悟空',21,'男','DS')
into student(sno, sname, sage, ssex, sdep) values('10008','孙尚香',19,'女','DS')
into student(sno, sname, sage, ssex, sdep) values('10009','百里守约',21,'男','ES')
into student(sno, sname, sage, ssex, sdep) values('10010','妲己',16,'女','ES')
select 1 from dual;

create table course(
  cno varchar2(20) primary key,
  cname varchar2(20) not null,
  cpre varchar2(20)
);
comment on table course is '课程信息';
comment on column course.cno is '课程号';
comment on column course.cname is '课程名称';
comment on column course.cpre is '课程先修课程';

insert all
into course values('1','数据结构','2')
into course values('2','操作系统','3')
into course values('3','C语言',null)
into course values('4','汇编','5')
into course values('5','设计模式',null)
select 1 from dual;

create table sc(
  sno varchar2(20) not null,
  cno varchar2(20) not null,
  grade number(10, 2) not null,
  constraint pk_sc primary key (sno, cno),
  constraint f_sno foreign key (sno) references student(sno),
  constraint f_cno foreign key (cno) references course(cno)
);
comment on table sc is '选课信息';
comment on column sc.sno is '学号';
comment on column sc.cno is '课程号';
comment on column sc.grade is '学号';

insert all
into sc values('10001','1',83.5)
into sc values('10002','2',92.5)
into sc values('10003','3',78)
into sc values('10004','4',87)
into sc values('10005','5',81)
into sc values('10006','1',93)
into sc values('10007','2',88.5)
into sc values('10008','3',77.5)
into sc values('10009','4',91.5)
into sc values('10010','5',100)
select 1 from dual;

commit;