目 录
课程目标： ........................................................................................................................... 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 流程控制 ....................................................................................................... 9
1.6 PL/SQL 的异常处理 ................................................................................................. 17
第 2 章 复合数据 .............................................................................................................. 22
2.1 PL/SQL 记录 ............................................................................................................ 22
2.2 PL/SQL 集合 ............................................................................................................ 28
第 3 章 PL/SQL 中的 SQL ............................................................................................... 37
3.1 PL/SQL 中的 DML .................................................................................................... 37
3.2 事务管理 .................................................................................................................. 46
3.3 数据检索与游标 ....................................................................................................... 49
3.4 游标变量和 REF CURSOR 类型 ............................................................................. 79
3.5 游标表达式 .............................................................................................................. 92
第 4 章 PL/SQL 应用程序结构 ......................................................................................... 96
4.1 过程、函数和参数 ................................................................................................... 96
4.2 包 ........................................................................................................................... 130
