Just for you! -灵犀笔记- 小拐 小木头
2.PL/SQL
程序结构
1. 结构组成: .............................................................................................................................................................................252
2. pl/sql 的开发环境: ...............................................................................................................................................................252
3. pl/sql 的字符集: ...................................................................................................................................................................252
4. pl/sql 的标识符: ...................................................................................................................................................................252
5. 注释: .....................................................................................................................................................................................252
6. 变量的声明: .........................................................................................................................................................................253
3.PL/SQL
数据类型
1. pl/sql 数据类型.....................................................................................................................................................................254
2. 数字类型...............................................................................................................................................................................254
3. 字符型 .................................................................................................................................................................................254
4. 布尔型...................................................................................................................................................................................255
5. 日期型...................................................................................................................................................................................255
6. %type 类型............................................................................................................................................................................255
7. Record 类型...........................................................................................................................................................................256
8. %rowtype 类型......................................................................................................................................................................257
9. table 类型...............................................................................................................................................................................257
10. 变量的作用域: ...................................................................................................................................................................258
4. PL/SQL
中的控制语句
1. 条件语句(分支语句) ...........................................................................................................................................................259
2. 循环语句...............................................................................................................................................................................259
3. GOTO 语句...........................................................................................................................................................................260
5.PL/SQL
游标
1. 游标(cursor) .........................................................................................................................................................................260
2. 游标的属性: .........................................................................................................................................................................261
3. 练习: .................................................................................................................................................................................261
4. 游标 带参数传递.................................................................................................................................................................262
5. 练习:创建两张结构相同的表...........................................................................................................................................262
6.
第六章
PL/SQL
异常
1. 异常处理: .........................................................................................................................................................................263
7.PL/SQL
存储过程
1. 匿名语句块...........................................................................................................................................................................264
2. 命名语句块...........................................................................................................................................................................264
3. procedure: .............................................................................................................................................................................264
4. function .................................................................................................................................................................................266
5. 删除过程与函数...................................................................................................................................................................268
8.PL/SQL
包
1. 包: .........................................................................................................................................................................................268
9.PL/SQL
触发器
1. trigger 与 function,procedure 的比较....................................................................................................................................270
2. trigger 的触发事件:在数据库的表中执行 DML 语句. ...................................................................................................270
3. TRIGGER 的作用.................................................................................................................................................................270
4. trigger 的种类: ......................................................................................................................................................................271
5. 注意: .....................................................................................................................................................................................271
10.
动态
PL/SQL
1. 使用动态 SQL 包来创建表: ................................................................................................................................................272
2. 使用动态 SQL 包来查询数据库的记录..............................................................................................................................273
=16= 小木头 小拐