§16.4.2 Oracle R2 新增加的包........................................................................................326
§16.5 PL/SQL 版本的演化......................................................................................................327
第 17 章 PL/SQL 块结构和组成元素.............................................................................................328
§17.1 PL/SQL 结构..................................................................................................................328
§17.2 PL/SQL 块.......................................................................................................................329
§17.3 标识符.............................................................................................................................329
§17.4 PL/SQL 变量类型..........................................................................................................330
§17.4.1 变量类型..............................................................................................................330
§17.4.2 复合类型(记录和表).....................................................................................331
§17.4.3 使用%ROWTYPE...............................................................................................333
§17.4.4 LOB 类型.............................................................................................................333
§17.4.5 用户定义的子类型.............................................................................................334
§17.4.6 数据类型的转换.................................................................................................336
§17.5 运算符和表达式(数据定义)..........................................................................................336
§17.5.1 关系运算符..........................................................................................................336
§17.5.2 一般运算符..........................................................................................................337
§17.5.3 逻辑运算符..........................................................................................................337
§17.6 变量赋值.........................................................................................................................337
§17.6.1 字符及数字运算特点.........................................................................................338
§17.6.2 Boolean 赋值.......................................................................................................338
§17.6.3 数据库赋值..........................................................................................................338
§17.6.4 可转换的类型赋值.............................................................................................339
§17.7 变量作用范围以可见性................................................................................................340
§17.8 注释.................................................................................................................................341
§17.9 简单例子.........................................................................................................................342
§17.9.1 简单数据插入例子.............................................................................................342
§17.9.2 简单数据删除例子.............................................................................................342
第 18 章 PL/SQL 处理流程.............................................................................................................343
§18.1 条件语句.........................................................................................................................343
§18.1.1 IF . . . THEN 条件语句.......................................................................................343
§18.1.2 IF . . . THEN ELSE 条件语句.............................................................................344
§18.1.3 IF . . . THEN ELSIF 条件语句............................................................................344
§18.1.4 CASE 条件语句..................................................................................................346
§18.2 循环语句.........................................................................................................................346
§18.2.1 Loop … end loop 简单循环................................................................................347
§18.2.2 while 简单循环....................................................................................................348
§18.2.3 FOR 循环.............................................................................................................348
§18.3 标号和 GOTO 语句........................................................................................................350
§18.4 NULL 语句.....................................................................................................................350
第 19 章 光标的使用........................................................................................................................351
§19.1 光标概念.........................................................................................................................351
§19.1.1 处理显式光标.....................................................................................................351
§19.1.2 处理隐式光标.....................................................................................................353
§19.2 光标循环.........................................................................................................................355