Oracle实验报告姓名学院：年级：班级：指导老师：实验一了解ORACLE环境，使用ORACLE数据库实用工具（验证性实验4学时）1.目的要求：了解ORACLE数据库的各个常用工具软件2.实验内容：在ORACEL数据库下使用SQL*PLUS ，SQL*PLUS Worksheet，PL/SQL Developer工具，企业管理器等实用工具与Oracle交互。

并在企业管理器中观察ORACLE的底层存储原理。

在PL/SQL Developer中书写简单的SQL语言。

简单SQL语句：select * from student;3.主要仪器设备及软件1）PC2）ORACLE数据库-------------------------------------------------------------------------实验二熟悉SQL语言（验证性实验4学时）1.目的要求在SQL*PLUS或PL/SQL Developer工具中编写SQL语句2.实验内容在ORACLE 数据库中定义用户，给用户赋权限，创建，修改和删除表格，视图等数据库对象，并向表格中插入，修改和删除数据。

体会SQL语言中ORACLE的“方言”。

对自己建立的表做查询：包括单表查询，多表查询，嵌套查询，分组查询，相关查询自定义用户：create user zy identified by qwer;赋权限：grant dba to zy;建表，插入数据：create table student(sno char(9) primary key,sname char(20) unique,ssex char (2),sage smallint,sdept char(20));insert into student(sno,sname,ssex,sage,sdept) values('001','李勇','男','20','CS');insert into student(sno,sname,ssex,sage,sdept)values('002','刘晨','女','19','CS');insert into student(sno,sname, ssex,sage,sdept)values('003','王敏','女','18','MA');insert into student(sno,sname,ssex,sage,sdept)values('004','李浩','男','19','MA');insert into student(sno,sname, ssex,sage,sdept)values('005','张力','男','19','IS');insert into student (sno,sname ,ssex ,sage ,sdept)values('006','胡蝶','女','20','MA');insert into student (sno,sname,ssex,sage,sdept) values('007','汤雨','男','20','IS');insert into student(sno,sname,ssex,sage,sdept) values('008','宁浩宇','男','19','MA');insert into student(sno,sname,ssex,sage,sdept)values('009','李明','男','20','MA');insert into student(sno,sname,ssex,sage,sdept)values('010','刘玉','女','18','IS');insert into student(sno,sname,ssex,sage,sdept)values('011','琳琳','男','20','CS');insert into student(sno,sname,ssex,sage,sdept)values('012','詹姆斯','男','20','CS');--课程表create table course(cno char(4) primary key,cname char(40),cpno char(4),ccredit smallint);insert into course(cno,cname,cpno,ccredit) values('1','数据库','5','4');insert into course(cno,cname,cpno,ccredit) values('2','数学','','2');insert into course(cno,cname,cpno,ccredit) values('3','信息系统','1','4'); insert into course(cno,cname,cpno,ccredit) values('4','操作系统','6','3'); insert into course(cno,cname,cpno,ccredit) values('5','数据结构','7','4'); insert into course(cno,cname,cpno,ccredit) values('6','数据处理','','2'); insert into course(cno,cname,cpno,ccredit) values('7','PASCAL语言','6','4'); insert into course(cno,cname,cpno,ccredit) values('8','C_语言','3','4');--选课表create table sc(sno char(9),cno char(4),grade smallint,primary key (sno,cno));insert into sc(sno,cno,grade) values('001','1','92');insert into sc(sno,cno,grade) values('001','2','85');insert into sc(sno,cno,grade) values('001','3','88');insert into sc(sno,cno,grade) values('002','1','92');insert into sc(sno,cno,grade) values('002','2','90');insert into sc(sno,cno,grade) values('002','3','80');insert into sc(sno,cno,grade) values('003','2','85');insert into sc(sno,cno,grade) values('003','4','95');insert into sc(sno,cno,grade) values('003','5','94');insert into sc(sno,cno,grade) values('004','1','98');insert into sc(sno,cno,grade) values('004','5','96');insert into sc(sno,cno,grade) values('004','6','86');insert into sc(sno,cno,grade) values('005','1','96');insert into sc(sno,cno,grade) values('005','3','96');insert into sc(sno,cno,grade) values('005','6','76');insert into sc(sno,cno,grade) values('006','2','86');insert into sc(sno,cno,grade) values('006','3','84');insert into sc(sno,cno,grade) values('006','6','96');insert into sc(sno,cno,grade) values('007','1','99');insert into sc(sno,cno,grade) values('007','4','75');insert into sc(sno,cno,grade) values('007','7','66');insert into sc(sno,cno,grade) values('008','2','86');insert into sc(sno,cno,grade) values('008','5','96');insert into sc(sno,cno,grade) values('009','8','88');insert into sc(sno,cno,grade) values('009','1','88');insert into sc(sno,cno,grade) values('009','3','81');insert into sc(sno,cno,grade) values('010','3','81');insert into sc(sno,cno,grade) values('010','6','88');insert into sc(sno,cno,grade) values('010','7','81');insert into sc(sno,cno,grade) values('010','8','51');insert into sc(sno,cno,grade) values('010','1','11');insert into sc(sno,cno,grade) values('011','5','99');insert into sc(sno,cno,grade) values ('011','6','44');单表查询：select * from student;多表查询：select * from student,sc where student.sno=sc.sno;嵌套查询：select * from student where sno in (select sno from sc);分组查询：select * from sc group by sno;相关查询：select cno from sc group by cno having count(*)>= (select count(*) f rom student );3.主要仪器设备及软件1）PC2）ORACLE数据库-------------------------------------------------------------------------实验三实现简单的PL/SQL程序（验证性实验4学时）1.目的要求编写简单的PL/SQL程序，熟悉PL/SQL编程环境2.实验内容在SQL*PLUS或PL/SQL Developer工具中编写PL/SQL的简单程序，熟悉PL/SQL的编程环境和代码结构。