PLSQLDeveloper中文超详细教程

唯唯

3052

239页

23次

2020-02-23

5墨值下载

PL/SQL Developer 7.0

用户指南

PL/SQL Developer 7.0

用户指南

目录..............................................................................................................................................................3

1. 介绍......................................................................................................................................................9

2. 安装....................................................................................................................................................13

2.1 系统需求 ...................................................... 13

2.2 工作站安装 .................................................... 13

2.3 基于服务器安装 ................................................ 13

2.4 脚本安装 ...................................................... 14

2.5 卸载 PL/SQL 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 PL/SQL 概览图 ................................................... 32

5.4 SQL 跟踪 ........................................................ 33

6. 专用 SQL............................................................................................................................................35

6.1 使用 SQL 窗口 ................................................. 35

6.2 结果表格处理 .................................................. 36

6.3 实例模式查询 .................................................. 40

6.4 连接查询 ...................................................... 41

6.5 置换变量 ...................................................... 42

of 239

5墨值下载

oracle 安装部署

相关文档

评论