ORACLE高级查询..各种各样的查法..重基础到深入资源-CSDN文库

ORACLE高级查询..各种各样的查法..重基础到深入

需积分: 35 126 浏览量 2009-08-10 13:42:39 上传评论收藏 47KB DOC 举报

资源详情

资源评论

资源推荐

SQL 练习题

创建表和输入数据

CREATE TABLE SCOTT.STUDENT

(SNO VARCHAR(3) NOT NULL,

SNAME VARCHAR(4) NOT NULL,

SSEX VARCHAR(2) NOT NULL,

SBIRTHDAY DATE,

CLASS VARCHAR(5));

CREATE TABLE SCOTT.COURSE

(CNO VARCHAR(5) NOT NULL,

CNAME VARCHAR(10) NOT NULL,

TNO VARCHAR(10) NOT NULL);

CREATE TABLE SCOTT.SCORE

(SNO VARCHAR(3) NOT NULL,

CNO VARCHAR(5) NOT NULL,

DEGREE NUMERIC(10, 1) NOT NULL);

CREATE TABLE SCOTT.TEACHER

(TNO VARCHAR(3) NOT NULL,

TNAME VARCHAR(4) NOT NULL, TSEX VARCHAR(2) NOT NULL,

TBIRTHDAY DATE NOT NULL, PROF VARCHAR(6),

DEPART VARCHAR(10) NOT NULL);

INSERT INTO SCOTT.STUDENT (SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES

(108 ,'曾华' ,'男' ,'1-9 月-1977',95033);

INSERT INTO SCOTT.STUDENT (SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES

(105 ,'匡明' ,'男' , '1-9 月-1976',95031);

INSERT INTO SCOTT.STUDENT (SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES

(107 ,'王丽' ,'女' , '1-1 月-1975',95033);

INSERT INTO SCOTT.STUDENT (SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES

(101 ,'李军' ,'男' ,'20-2 月-1976',95033);

INSERT INTO SCOTT.STUDENT (SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES

(109 ,'王芳' ,'女' ,'10-2 月-1976',95031);

INSERT INTO SCOTT.STUDENT (SNO,SNAME,SSEX,SBIRTHDAY,CLASS) VALUES

(103 ,'陆君' ,'男' ,'3-6 月-1974',95031);

INSERT INTO SCOTT.COURSE(CNO,CNAME,TNO)VALUES ('3-105' ,'计算机导论',825);

INSERT INTO SCOTT.COURSE(CNO,CNAME,TNO)VALUES ('3-245' ,'操作系统' ,804);

INSERT INTO SCOTT.COURSE(CNO,CNAME,TNO)VALUES ('6-166' ,'数据电路' ,856);

INSERT INTO SCOTT.COURSE(CNO,CNAME,TNO)VALUES ('9-888' ,'高等数学' ,100);

本内容试读结束，登录后可阅读更多

下载后可阅读完整内容，剩余3页未读，立即下载

评论0

内容反馈

fengqing_1

粉丝: 0
资源: 1

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip