NewMcgrawHill的博客

PVS-Studio 5.28通过，延长到任意日期，非常好用

很详细，很好用： ================================================== 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 实例模式查询 .................................................. 41 6.4 连接查询 ...................................................... 42 6.5 置换变量 ...................................................... 43 6.6 更新数据库 .................................................... 44 6.7 查看和编辑 XMLTYPE 列 .......................................... 45 6.8 直接查询导出 .................................................. 45 6.9 保存 SQL 脚本 .................................................. 45 6.10 创建标准查询 .................................................. 46 7. 命令窗口 ....................................................................................................................................... 47 7.1 输入 SQL 语句和命令 ............................................ 47 7.2 开发命令文件 .................................................. 48 7.3 支持命令 ...................................................... 49 8. 创建和修改非 PL/SQL 对象........................................................................................................ 52 8.1 表定义编辑器 .................................................. 53 8.2 序列定义编辑器 ................................................ 65 8.3 同义词定义编辑器 .............................................. 65 8.4 库定义编辑器 .................................................. 66 8.5 目录定义编辑器 ................................................ 66 8.6 作业定义编辑器 ................................................ 67 8.7 队列定义编辑器 ................................................ 67 8.8 队列表定义编辑器 .............................................. 68 8.9 用户定义编辑器 ................................................ 69 8.10 角色定义编辑器 ................................................ 72 8.11 概要文件定义编辑器 ............................................ 73 8.12 数据库连接定义编辑器 .......................................... 73 9. DBMS 调度程序 .............................................................................................................................. 74 9.1 创建对象 ...................................................... 80 9.2 编辑对象 ...................................................... 80 9.3 删除对象 ...................................................... 80 9.4 查看作业运行 .................................................. 80 9.5 查看正在运行的作业 ............................................ 82 10. 图表 ............................................................................................................................................... 83 10.1 创建图表 ...................................................... 83 10.2 缩放 .......................................................... 87 10.3 保存和打开图表文件 ............................................ 87 10.4 更新图表 ...................................................... 87 10.5 打印图表 ...................................................... 88 10.6 导出图表 ...................................................... 88 11. 报告 ............................................................................................................................................... 89 11.1 标准报告 ...................................................... 89 11.2 定制报告 ...................................................... 90 11.3 变量 .......................................................... 91 11.4 精制版面 ...................................................... 96 11.5 风格库 ....................................................... 103 11.6 选项 ......................................................... 104 11.7 报告菜单 ..................................................... 106 12. 图形 ............................................................................................................................................. 107 13. 工程 ............................................................................................................................................. 109 13.1 创建一个新工程 ............................................... 109 13.2 保存工程 ..................................................... 110 13.3 添加文件到工程 ............................................... 110 13.4 添加数据库对象到工程 ......................................... 110 13.5 用工程项目工作 ............................................... 111 13.6 编译工程 ..................................................... 112 14. 任务项目 ..................................................................................................................................... 113 14.1 创建任务项目 ................................................. 114 14.2 编辑任务项目 ................................................. 114 14.3 关闭任务项目 ................................................. 115 14.4 删除任务项目 ................................................. 115 15. 窗口、数据库会话和事务 ......................................................................................................... 116 15.1 会话模式 ..................................................... 116 15.2 运行于多路会话或双路会话模式 ................................. 116 16. 浏览对象 ..................................................................................................................................... 117 16.1 使用对象浏览器 ............................................... 117 16.2 对象浏览器过滤器 ............................................. 124 16.3 对象浏览器文件夹 ............................................. 125 17. 浏览文件 ..................................................................................................................................... 127 17.1 设置文件浏览器 ............................................... 127 17.2 使用文件浏览器 ............................................... 129 18. 首选项 ......................................................................................................................................... 130 18.1 ORACLE – 连接 ................................................. 131 18.2 ORACLE – 选项 ................................................. 132 18.3 ORACLE – 编译器 ............................................... 134 18.4 ORACLE – 调试器 ............................................... 136 18.5 ORACLE – 输出 ................................................. 137 18.6 ORACLE – 跟踪 ................................................. 138 18.7 ORACLE – 概览图 ............................................... 138 18.8 ORACLE – 登录历史 ............................................. 140 18.9 ORACLE – 提示 ................................................. 141 18.10 用户界面 – 选项 ............................................. 143 18.11 用户界面 – 工具栏 ........................................... 145 18.12 用户界面 – 对象浏览器 ....................................... 145 18.13 用户界面 – 编辑器 ........................................... 147 18.14 用户界面 – 字体 .............................................. 150 18.15 用户界面 – 代码助手 .......................................... 151 18.16 用户界面 – 键配置 ............................................ 152 18.17 用户界面 – 外观 .............................................. 153 18.18 用户界面 – NLS 选项 .......................................... 155 18.19 窗口类型 – 程序窗口 .......................................... 157 18.20 窗口类型 – SQL 窗口 .......................................... 159 18.21 窗口类型 – 测试窗口 .......................................... 161 18.22 窗口类型 – 计划窗口 .......................................... 162 18.23 工具 – 差异 .................................................. 162 18.24 工具 – 数据生成器 ............................................ 163 18.25 工具 – 任务列表 .............................................. 163 18.26 工具 – 重新调用声明 .......................................... 164 18.27 文件 – 目录 .................................................. 165 18.28 文件 – 扩展名 ................................................ 167 18.29 文件 – 格式 .................................................. 167 18.30 文件 – 备份 .................................................. 168 18.31 文件 – HTML/XML .............................................. 169 18.32 其他 – 打印 .................................................. 170 18.33 其他 – 更新与消息 ............................................ 171 18.34 首选项集 ..................................................... 172 19. 工具 .............................................................................................................................................174 19.1 对象浏览器 ................................................... 174 19.2 查找数据库对象 ............................................... 175 19.3 编译无效对象 ................................................. 176 19.4 导出表 ....................................................... 177 19.5 导入表 ....................................................... 180 19.6 导出用户对象 ................................................. 182 19.7 文本导入器 ................................................... 183 19.8 ODBC 导入器 ................................................... 188 19.9 数据生成器 ................................................... 190 19.10 比较用户对象 ................................................. 194 19.11 比较表数据 ................................................... 196 19.12 事件监视器 ................................................... 199 19.13 会话 ......................................................... 200 19.14 自定义工具 ................................................... 202 19.15 测试管理器 ................................................... 207 20. 编辑器 .........................................................................................................................................211 20.1 选择功能 ..................................................... 211 20.2 列选择 ....................................................... 211 20.3 代码助手 ..................................................... 212 20.4 重新调用语句 ................................................. 213 20.5 专用复制 ..................................................... 214 20.6 前后关系敏感帮助 ............................................. 215 20.7 数据库对象弹出式菜单 ......................................... 215 20.8 解释计划 ..................................................... 215 20.9 宏 ........................................................... 215 20.10 书签 ......................................................... 216 20.11 颜色标记 ..................................................... 217 20.12 代码目录 ..................................................... 218 20.13 代码层次 ..................................................... 219 20.14 代码折叠 ..................................................... 219 20.15 拆分编辑 ..................................................... 220 20.16 超链接导航 ................................................... 221 20.17 导航按钮 ..................................................... 221 20.18 重构 ......................................................... 222 20.19 搜索栏 ....................................................... 222 21. 大数据编辑器 ............................................................................................................................. 224 21.1 编辑纯文本 ................................................... 225 21.2 编辑 RTF ..................................................... 225 21.3 编辑 XML ..................................................... 226 21.4 编辑图象 ..................................................... 227 21.5 编辑十六进制数据 ............................................. 227 21.6 调用外部查看器或编辑器 ....................................... 229 22. 查询设计器 ................................................................................................................................. 231 22.1 创建新的 SELECT 语句 ........................................... 231 22.2 修改现有的SELECT 语句 .......................................... 235 22.3 处理查询定义 ................................................. 235 22.4 查询设计器首选项 ............................................. 236 22.5 查询设计器插件 ............................................... 237 23. PL/SQL 美化器 ........................................................................................................................... 238 23.1 定义选项 ..................................................... 238 23.2 定义规则 ..................................................... 239 23.3 使用美化器 ................................................... 240 23.4 取消格式化 ................................................... 240 24. 模板 ............................................................................................................................................. 241 24.1 模板窗口 ..................................................... 241 24.2 使用模板 ..................................................... 242 24.3 创建和修改模板 ............................................... 243 25. 窗口列表 .....................................................................................................................................248 26. 可停放和浮动的工具 ..................................................................................................................249 27. 授权 .............................................................................................................................................251 27.1 允许授权 ..................................................... 251 27.2 定义授权 ..................................................... 252 27.3 禁用授权 ..................................................... 253 28. ORACLE 文件系统 (OFS) ............................................................................................................254 28.1 OFS 管理器 .................................................... 254 28.2 OFS 用法 ...................................................... 256 29. 帮助系统 .....................................................................................................................................258 29.1 MS 帮助文件 ................................................... 258 29.2 HTML 手册 ..................................................... 258 30. 定制 .............................................................................................................................................262 30.1 首选项 ....................................................... 262 30.2 窗口版面 ..................................................... 262 30.3 在线文档 ..................................................... 262 30.4 命令行参数 ................................................... 264 30.5 SQL、PL/SQL、命令、JAVA 和 XML 关键词 .......................... 267 30.6 插件 ......................................................... 267

Todd for Oracle中文简明手册

1073页啊，够爽吧： Introduction 15 New in This Release 15 Introduction to Toad 23 DB Admin Module 24 Toad and Oracle Enterprise Manager 29 Quick Search Bar 30 Additional Resources 31 Working with other Quest Products 32 Knowledge Xpert 32 Using SQL Optimizer with Toad 32 Benchmark Factory 33 Quest Code Tester Integration 35 Toad Basics 37 Toad Tips 37 Errors 37 RAC Support 37 Task Bar & Status Bar 38 Toolbars, Menus and Shortcut Keys 40 Installation and Administration of Toad 64 Window Privileges and Toad 64 Toad for Oracle, Read-Only 64 Registering Toad 65 Silent Installation 66 Group Policy Management 71 Citrix Support 71 SQL*Net Versions 72 Configuration Files 73 Server Side Objects Installation 93 Connecting to Oracle 97 Server Login Window 97 Create New Connection 99 Selecting Connection Color 101 SET ROLE 101 Auto Connect 103 Save Passwords for Connections 104 Select and View Favorite Connections 104 Organize your login display 105 Use Existing Connection 106 SQLNET Editor 106 LDAP Editor 107 Oracle Homes 108 TNSNames Editor 111 Tutorials 119 CodeXpert 119 PL/SQL Debugger 121 SQL*Loader 140 Team Coding 158 RMAN Templates 164 RMAN Scripts in Toad 164 Working with RMAN Templates 164 Executing RMAN Scripts from Toad 165 Comparing 166 Data Duplicates 166 Compare Single Objects 166 Comparing Databases 167 Comparing Data 174 Compare Files (Difference Viewer) 176 Comparing Schemas 180 Controlling Sessions 188 Select Session 188 End Connections 188 Test Connections 188 Configure User Lists 188 Session Information 189 Change Password 190 Commit & Rollback 190 Connect and Disconnect 191 DBMS_Flashback 191 Diagnosing Problems 193 View Extents 193 Identify Space Deficits 193 Log Switch Frequency Map 194 Tablespace Map 194 TKProf Interface Wizard 196 Undo Advisor 198 Segment Advisor 200 LogMiner Interface 203 Health Check 207 Trace File Browser 226 CodeXpert 231 Database Administration 259 Audit SQL/Sys Privs 259 NLS Parameters 260 Toad Features Security 260 ASM Manager 263 Audit Objects 269 Multiple Object Privileges 270 Oracle Parameters 272 Tablespaces 274 Redo Log Manager 282 Importing and Exporting Data 285 Data Pump 285 Export Dataset 304 Export DDL 310 Export File Browser 318 General Export 324 General Import 329 Generate Database Script 341 Generate Schema Script 342 Managing Projects 346 Using Automation Designer to Control Toad 346 Project Manager 387 Query Viewer 416 SQL Command Recall 418 Script Manager 419 Monitoring 431 Toad Server Statistics 431 SQL Monitor 432 Toad UNIX Monitor 432 ADDM/AWR 434 Database Browser 446 Database Monitor 449 Database Probe 453 Index Monitoring 458 Instance Manager 460 Session Browser 466 SGA Trace/Optimization 483 StatsPack Browser 486 Top Session Finder 495 Optimizing (Tuning) 499 DBMS_REDEFINITION Wizard 499 Estimate Index Size 500 Estimate Table Size 501 Explain Plan 503 Pinned Code 504 Repair Chained Rows 505 Rebuild Table 506 Unix Kernel Parms 507 Windows Registry Parms 508 Analyze All Objects 509 Profilers 512 Oracle Tuning 523 Rebuild Multiple Objects 525 Options 535 Formatting Options 535 Toad Options 536 Language Management 603 Printing 620 Printing 620 Print Grid 620 Report Link Designer 620 Reporting 623 Toad Control Files 623 Dependencies 624 ER Diagrams 624 Explain Plans 631 Code Road Map 636 HTML Schema Doc Generator 641 Master/Detail Browser 643 Reports Manager 648 Reporting from Data Grids 655 Spool SQL 659 Spool SQL 659 Utilities 660 Archive 660 Wrap Code 660 Service Manager 661 External tools 662 FTP 665 Java Manager 668 Network Utilities 672 Task Scheduler 676 Unix Job Scheduler 678 Source Control and Team Coding 693 Support for Version Control Products 693 Third Party File Based Source Control 694 Team Coding 697 Status in the Editor Status Bar or Team Coding Viewer Status Column 707 Detailed File Properties 708 Checking Objects and Scripts in and out 709 Using Automatic Check-in and Automatic Check-out 709 Manually check-in or check-out 709 Entering Comments on Check in or out 710 Check In All 711 Undo Checkout 712 Freezing an Object 713 TC Locks not selected 726 TC Locks selected 726 Working from the Command Line 738 Command Line Syntax 738 Converting Old Settings Files to Actions 743 Command Line Passwords 744 Export Tables, Views, SQL Queries from the Command Line 744 Run Analyze Objects from the Command Line 745 Run CodeXpert from the Command Line 750 Running Actions from the Command Line 751 Run Compare Databases from Command Prompt 754 Run Compare Schemas from a Command Prompt 757 Run Copy to another Schema from Command Prompt 757 Run Generate Database Script from a Command Prompt 758 Run Generate Schema Script from Command Line 760 Run Rebuild Objects from the Command Prompt 762 Run Reports Manager from the Command Line 766 Using Variables 768 Using Variables 768 Working with Code 769 Editor 769 Debugging 819 Query Builder 851 Working with Data 861 Column Names Supported 861 Graph Properties 861 OPS$ Accounts 861 Viewing or Hiding Docked Windows 862 Viewing Source Surrounding a PL/SQL Error 863 Dataset Operations 864 Data Grids 866 DBMS Output 881 Finding Data 883 Generate Test Data 890 Working with Database Objects 896 Schema Browser Overview 896 Auto-Refreshing the Datagrid 897 Icon Legend 898 Privileges 898 Schema Browser Toolbars 899 Statement Processing 900 Create Objects in Another Schema 900 Personalizing the Schema Browser 900 General Schema Browser Actions 903 Browser Filters 907 Clusters 912 Constraints 914 Contexts 917 DB Links 918 Dimensions 920 Directories 921 Favorites 923 Flashback Archives 924 Functions 926 Indexes 928 Invalid Objects 929 Java 931 Jobs 933 Libraries 936 Materialized Views (Snapshots) 938 Materialized View (Snapshot) Logs 940 Oracle Scheduler 941 Packages 953 Policies 955 Policy Groups 956 Procedures 957 Profiles 959 Queue Tables 960 Queues 964 Recycle Bin 966 Refresh Groups 968 Resource Consumer Groups 970 Resource Plans 972 Roles 974 Rollback Segments 975 Sequences 977 Synonyms 978 System Privileges 980 Tables 981 Tablespaces 996 Triggers 1002 Types 1004 Users 1010 Views 1012 Troubleshooting 1017 Unicode Troubleshooting 1017 Hints and Tips: Connecting To Personal Oracle 1018 Hints and Tips: Table Does Not Exist Errors 1019 Create Support Bundles 1019 Toad Advisor 1019 Contact Quest 1021 Contact Quest Support 1021 Contact Quest Software 1021 About Quest Software, Inc 1021 Appendix: Contact Quest 1022 Contact Quest Support 1022 Contact Quest Software 1022 About Quest Software, Inc 1022 Index 1023

非常完整的财务系统源码，希望对有需要的朋友有帮助。

一个人事管理系统设计框架，希望对感兴趣的朋友有用！

精通CSS高级Web标准解决方案(CSS Mastery)