Oracle PL/SQL 开发基础
目 录
课程目标：..........................................................................................................................1
第 1 章 PL/SQL 语言基础.................................................................................................2
1.1 什么是 PL/SQL.........................................................................................................2
1.2 PL/SQL 块结构基础..................................................................................................2
1.3 PL/SQL 的数据与数据类型.......................................................................................5
1.4 PL/SQL 的操作符......................................................................................................8
1.5 PL/SQL 流程控制....................................................................................................10
1.6 PL/SQL 的异常处理................................................................................................18
第 2 章 复合数据.............................................................................................................22
2.1 PL/SQL 记录...........................................................................................................23
2.2 PL/SQL 集合...........................................................................................................29
第 3 章 PL/SQL 中的 SQL..............................................................................................37
3.1 PL/SQL 中的 DML...................................................................................................37
3.2 事务管理.................................................................................................................46
3.3 数据检索与游标......................................................................................................49
3.4 游标变量和 REF CURSOR 类型.............................................................................80
3.5 游标表达式..............................................................................................................94
第 4 章 PL/SQL 应用程序结构........................................................................................98
4.1 过程、函数和参数...................................................................................................98
4.2 包..........................................................................................................................133
2 / 171
评论0