《PL/SQL Developer中文使用手册(最新版 7.0)》是一本全面介绍PL/SQL Developer工具的指南书籍,内容涵盖了软件的各项功能及操作技巧,旨在帮助用户快速掌握并高效利用该开发环境。
目录
1. 介绍.........................................................................................................................9
2. 安装...........................................................................................................................13
2.1 系统需求......................................................13
2.2 工作站安装....................................................13
2.3 基于服务器安装................................................13
2.4 脚本安装......................................................14
2.5 卸载 PLSQL DEVELOPER...........................................14
3. 编写程序...............................................................................................................15
3.1 创建程序......................................................15
3.2 保存程序......................................................16
3.3 修改程序......................................................17
3.4 编译程序......................................................17
3.5 置换变量......................................................18
4. 测试程序...............................................................................................................19
4.1 创建测试脚本..................................................19
4.2 运行测试脚本..................................................20
4.3 变量类型......................................................21
4.4 保存测试脚本..................................................22
4.5 跟踪运行时间错误..............................................23
4.6 包声明和 JAVA 会话声明.........................................23
4.7 查看结果集....................................................24
4.8 查看 DBMS_OUTPUT................................................24
4.9 查看 HTP 输出.................................................24
4.10 调试..........................................................24
4.11 跟踪运行......................................................28
4.12 回归测试......................................................29
5. 优化.......................................................................................................................30
5.1 使用解释计划窗口..............................................30
5.2 自动统计......................................................31
5.3 PLSQL 概览图...................................................32
5.4 SQL 跟踪........................................................33
6. 专用 SQL...............................................................................................................35
6.1 使用 SQL 窗口.................................................35
6.2 结果表格处理..................................................36
6.3 实例模式查询..................................................40
6.4 连接查询......................................................41
6.5 置换变量......................................................42
7. 命令窗口...............................................................................................................46
7.1 输入 SQL 语句和命令............................................46
7.2 开发命令文件..................................................47
7.3 支持命令......................................................48
8. 创建与修改非 PLSQL 对象.................................................................................................51
8.1 表定义编辑器..................................................51
8.2 序列定义编辑器................................................63
8.3 同义词定义编辑器..............................................63
8.4 库定义编辑器..................................................64
8.5 目录定义编辑器................................................64
8.6 作业定义编辑器................................................65
8.7 队列定义编辑器................................................65
8.8 队列表定义编辑器..............................................66
8.9 用户定义编辑器................................................67
8.10 角色定义编辑器................................................70
8.11 概要文件定义编辑器............................................71
8.12 数据库连接定义编辑器..........................................71
9. 图表...........................................................................................................................72
9.1 创建图表......................................................72
9.2 保存和打开图表文件............................................73
9.3 调整图表布局与样式............................................80
10. 授权管理...............................................................................................................223
10.1 启用授权.....................................................223
10.2 定义授权.....................................................224
10.3 停用授权.....................................................225
11. ORACLE 文件系统 (OFS).................................................................................................226
11.1 OFS 管理器...................................................226
11.2 OFS 使用说明..................................................228
12. 帮助系统...............................................................................................................23