Oracle经典教程.doc
版权申诉
63 浏览量
2023-09-06
11:38:28
上传
评论
收藏 7.51MB DOC 举报
Oracle 经典教程
走进 Oracle .............................................................................................................................2
1. Oracle 简介.......................................................................................................................4
2. Oracle 安装.......................................................................................................................5
3. Oracle 客户端工具.........................................................................................................10
4. Oracle 服务.....................................................................................................................17
5. Oracle 启动和关闭.........................................................................................................18
6. Oracle 用户和权限.........................................................................................................19
7. 本章总结 ........................................................................................................................22
8. 本章练习 ........................................................................................................................23
SQL 数据操作和查询 .............................................................................................................26
1. SQL 简介 .........................................................................................................................27
2. Oracle 数据类型.............................................................................................................27
3. 创建表和约束 ................................................................................................................28
4. 数据操纵语言（DML）.................................................................................................31
5. 操作符 ............................................................................................................................36
6. 高级查询 ........................................................................................................................37
7. 本章总结 ........................................................................................................................45
8. 本章练习 ........................................................................................................................46
子查询和常用函数..................................................................................................................49
1. 子查询 ............................................................................................................................50
2. Oracle 中的伪列.............................................................................................................52
3. Oracle 函数.....................................................................................................................55
4. 本章总结 ........................................................................................................................64
5. 本章练习 ........................................................................................................................65
表空间、数据库对象..............................................................................................................68
1. Oracle 数据库对象.........................................................................................................69
2. 同义词 ............................................................................................................................69
3. 序列 ................................................................................................................................72
4. 视图 ................................................................................................................................74
5. 索引 ................................................................................................................................76
6. 表空间 ............................................................................................................................78
7. 本章总结 ........................................................................................................................82
8. 本章练习 ........................................................................................................................83
剩余133页未读，继续阅读
资源评论
