大型数据库技术与应用上机.pdf

《大型数据库技术与应用上机.pdf》由会员分享，可在线阅读，更多相关《大型数据库技术与应用上机.pdf（5页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。

1、1/5 大型数据库应用技术上机2（1）SQL*Plus 的使用（如何启动、登录到DB、创建一个表）；写出实验过程。“cmd”（启动）“sqlplus/nolog”（登录到 DB）“connect sys/manager123 as sysdba”）(创建一个表)SQL create table a 2 (a_name varchar2(30),3 a_phone number(11),4 a_birthday date)。（2）模糊查询（%、_）的应用；写出实验过程（选择SH 模式下的sales表）。首先进入 SH模式下：（1）sys以实验室的身份登录；（2）执行：SQLalter user

2、sh identified by sh account unlock。（3）Connect sh/sh。转换到 sh模式下或用 sql develop连接到 sh模式下。2/5（查询）SQL select AMOUNT_SOLD 2 from sales 3 where AMOUNT_SOLD like 1001%。（3）学生选课业务的连接查询应用；写出实验过程（创建2 个表、连接查询语句的应用）。创建两个表：文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ

3、10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:C

4、J10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:

5、CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码

6、:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编

7、码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档

8、编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文

9、档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z93/5 插入三条记录：内连接：文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10

10、A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A1

11、0A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A

12、10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8

13、A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O

14、8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6

15、O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E

16、6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z94/5（4）利用创建序列及其应用；写出实验过程（创建一个表及序列，往表中插入数据，其中id 列使用序列）。利用第（3）题的表 student,再 创建一个序列 seq：向表中插入记录：查询结果显示:（5）group by及 having子句的应用；写出实验过程（针对SH模式中的相关表）。文档编码:C

17、J10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:

18、CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码

19、:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编

20、码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档

21、编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文

22、档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9

23、文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z95/5 查看 Eelctronics类中每个子类的平均销售额：查看 Eelctron

24、ics类中平均销售额大于300的子产品组：文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8

25、E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD

26、8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 H

27、D8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6

28、HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6

29、 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9文档编码:CJ10L6Y9C8M6 HD8E6O8A10A9 ZE2L7E10J1Z9