plsql developer 中文文档huabian - 乐橙lc8

plsql developer 中文文档huabian

2019-02-14 11:17:09 | 作者: 鸿骞 | 标签: 修正,用户界面,用户 | 浏览: 8485

PL/SQL Developer 7.0 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 4 PL/SQL Developer 7.0 用户攻略 6.6 更新数据库....................................................43 6.7 检查和修正 XMLTYPE 列..........................................44 6.8 直接查询导出..................................................44 6.9 保存 SQL 脚本..................................................44 6.10 创立规范查询..................................................45 7. 指令窗口............................................................................................................................................46 7.1 输入 SQL 句子和指令............................................46 7.2 开发指令文件..................................................47 7.3 支撑指令......................................................48 8. 创立与修正非 PL/SQL 目标............................................................................................................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 保存和翻开图表文件............................................75 9.3 更新图表......................................................75 10. 陈述....................................................................................................................................................76 10.1 规范陈述......................................................76 10.2 定制陈述......................................................77 10.3 变量..........................................................78 10.4 精制版面......................................................83 10.5 风格库........................................................90 10.6 选项..........................................................91 10.7 陈述菜单......................................................93 11. 图形....................................................................................................................................................94 12. 工程....................................................................................................................................................97 12.1 创立一个新工程................................................97 12.2 保存工程......................................................98 12.3 增加文件到工程................................................98 12.4 增加数据库目标到工程..........................................98 PL/SQL Developer 7.0 用户攻略 5 12.5 用工程项目作业................................................99 12.6 编译工程......................................................99 13. 使命项目..........................................................................................................................................101 13.1 创立使命项目.................................................102 13.2 修正使命项目.................................................102 13.3 封闭使命项目.................................................103 13.4 删去使命项目.................................................103 14. 窗口、数据库会话和业务.............................................................................................................104 14.1 会话形式.....................................................104 14.2 运转于多路会话或双路会话形式.................................104 15. 阅读目标..........................................................................................................................................105 15.1 运用阅读器...................................................105 15.2 阅读器过滤器.................................................110 15.3 阅读器文件夹.................................................111 16. 首选项..............................................................................................................................................114 16.1 ORACLE - 衔接.................................................115 16.2 ORACLE - 选项.................................................116 16.3 ORACLE - 调试器...............................................117 16.4 ORACLE - 输出.................................................118 16.5 ORACLE - 盯梢.................................................119 16.6 ORACLE - 概览图...............................................119 16.7 ORACLE - 登录前史.............................................121 16.8 ORACLE - 提示.................................................122 16.9 用户界面 - 选项.............................................124 16.10 用户界面 - 东西栏...........................................125 16.11 用户界面 - 阅读器...........................................126 16.12 用户界面 - 修正器...........................................127 16.13 用户界面 - 字体.............................................129 16.14 用户界面 - 代码帮手.........................................130 16.15 用户界面 - 键装备...........................................131 16.16 用户界面 - 外观.............................................132 16.17 用户界面 - 日期/时刻........................................133 16.18 窗口类型 - 程序窗口.........................................134 16.19 窗口类型 - SQL 窗口.........................................136 16.20 窗口类型 - 测验窗口.........................................138 16.21 窗口类型 - 方案窗口.........................................138 16.22 东西 - 差异.................................................139 16.23 东西 - 数据生成器...........................................139 16.24 东西 - 使命列表.............................................140 16.25 东西 - 从头调用声明.........................................140 6 PL/SQL Developer 7.0 用户攻略 16.26 文件 - 目录..................................................141 16.27 文件 - 扩展名................................................142 16.28 文件 - 格局..................................................143 16.29 文件 - 备份..................................................144 16.30 文件 - HTML/XML..............................................145 16.31 其它 - 打印..................................................146 16.32 其它 - 更新与音讯............................................147 16.33 首选项集.....................................................148 17. 东西.................................................................................................................................................150 17.1 阅读器.......................................................150 17.2 查找数据库目标...............................................151 17.3 编译无效目标.................................................152 17.4 导出表.......................................................153 17.5 导入表.......................................................156 17.6 导出用户目标.................................................158 17.7 文本导入器...................................................159 17.8 ODBC 导入器..................................................163 17.9 数据生成器...................................................165 17.10 比较用户目标.................................................169 17.11 比较表数据...................................................171 17.12 事情监视器...................................................173 17.13 会话.........................................................174 17.14 自界说东西...................................................176 17.15 测验管理器...................................................181 18. 修正器.............................................................................................................................................185 18.1 挑选功用.....................................................185 18.2 列挑选.......................................................185 18.3 指引线.......................................................186 18.4 代码帮手.....................................................186 18.5 从头调用句子.................................................187 18.6 专用仿制.....................................................188 18.7 前后联系灵敏协助.............................................189 18.8 数据库目标弹出式菜单.........................................189 18.9 解说方案.....................................................189 18.10 宏...........................................................189 18.11 书签.........................................................191 18.12 色彩符号.....................................................191 18.13 代码目录.....................................................192 18.14 代码层次.....................................................193 18.15 超链接导航...................................................193 18.16 导航按钮.....................................................194 PL/SQL Developer 7.0 用户攻略 7 18.17 重构.........................................................194 18.18 查找栏.......................................................195 19. 大数据修正器..................................................................................................................................197 19.1 修正纯文本...................................................198 19.2 修正 RTF.....................................................198 19.3 修正 XML.....................................................199 19.4 修正图象.....................................................200 19.5 修正十六进制数据.............................................200 19.6 调用外部检查器或修正器.......................................202 20. 查询规划器......................................................................................................................................204 20.1 创立新的 SELECT 句子...........................................204 20.2 修正现有的 SELECT 句子.........................................208 20.3 处理查询界说.................................................208 20.4 查询规划器首选项.............................................209 20.5 查询规划器插件...............................................210 21. PL/SQL 美化器...............................................................................................................................211 21.1 界说选项.....................................................211 21.2 界说规矩.....................................................212 21.3 运用美化器...................................................213 22. 模板..................................................................................................................................................214 22.1 模板窗口.....................................................214 22.2 运用模板.....................................................215 22.3 创立和修正模板...............................................216 23. 窗口列表..........................................................................................................................................221 24. 可停放和起浮的东西.....................................................................................................................222 25. 授权..................................................................................................................................................223 25.1 启用授权.....................................................223 25.2 界说授权.....................................................224 25.3 停用授权.....................................................225 26. ORACLE 文件体系 (OFS)...............................................................................................................226 26.1 OFS 管理器...................................................226 26.2 OFS 用法.....................................................228 27. 协助体系..........................................................................................................................................230 27.1 MS 协助文件..................................................230 27.2 HTML 手册....................................................230 28. 定制..................................................................................................................................................234 28.1 首选项.......................................................234 28.2 窗口版面.....................................................234 28.3 在线文档.....................................................234 8 PL/SQL Developer 7.0 用户攻略 28.4 指令行参数...................................................236 28.5 SQL、PL/SQL、指令、JAVA 和 XML 关键词.........................238 28.6 插件...............

版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表乐橙lc8立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章