oracle 学生信息表

create table student(

sno char(5),

sname varchar(20),

sage number(3),

ssex char(2),

sdept char(2)

);

create table course(

cno char(2),

cname varchar(20),

cpno char(2),

ccredit number(3)

);

create table sc(

sno char(5),

cno char(2),

grade number(3)

);

insert into student values('98001','钱横',18,'男','cs');

insert into student values('98002','王林',19,'女','cs');

insert into student values('98003','李明',20,'男','is');

insert into student values('98004','赵三',16,'女','ma');

insert into course values('1','数据库系统','5',4);

insert into course values('2','数学分析',null,2);

insert into course values('3','信息系统导论','1',3);

insert into course values('4','操作系统原理','6',3);

insert into course values('5','数据结构','7',4);

insert into course values('6','数据处理基础', null,4);

insert into course values('7','C语言','6',3);

insert into sc values('98001','1',87);

insert into sc values('98001','2',67);

insert into sc values('98001','3',90);

insert into sc values('98002','2',95);

insert into sc values('98002','3',85);

本文来源：https://www.wddqw.com/doc/e56a36f39b89680202d82502.html