首页 星云 工具 资源 星选 资讯 热门工具
:

PDF转图片 完全免费 小红书视频下载 无水印 抖音视频下载 无水印 数字星空

plsql12345678

前端 46.45MB 23 需要积分: 1
立即下载

资源介绍:

plsql12345678
PL/SQL Developer 7.1
User’s Guide
March 2007
PL/SQL Developer 7.1 User’s Guide 3
Contents
CONTENTS....................................................................................................................................................3
1. INTRODUCTION .............................................................................................................................9
2. INSTALLATION ............................................................................................................................13
2.1 SYSTEM REQUIREMENTS.......................................................................................................... 13
2.2 WORKSTATION INSTALLATION ...............................................................................................13
2.3 SERVER BASED INSTALLATION................................................................................................13
2.4 SCRIPTED INSTALLATION.........................................................................................................14
2.5 UNINSTALLING PL/SQL DEVELOPER .....................................................................................14
3. WRITING PROGRAMS ...............................................................................................................15
3.1 CREATING A PROGRAM ............................................................................................................15
3.2 SAVING A PROGRAM ................................................................................................................16
3.3 MODIFYING A PROGRAM .........................................................................................................17
3.4 COMPILING A PROGRAM ..........................................................................................................17
3.5 SUBSTITUTION VARIABLES ...................................................................................................... 18
4. TESTING PROGRAMS ................................................................................................................19
4.1 CREATING A TEST SCRIPT ....................................................................................................... 19
4.2 EXECUTING A TEST SCRIPT ..................................................................................................... 20
4.3 VARIABLE TYPES......................................................................................................................21
4.4 SAVING TEST SCRIPTS .............................................................................................................22
4.5 TRACKING RUN-TIME ERRORS ................................................................................................. 23
4.6 PACKAGE STATES & JAVA SESSION STATES ........................................................................... 23
4.7 VIEWING RESULT SETS.............................................................................................................23
4.8 VIEWING DBMS_OUTPUT ......................................................................................................... 23
4.9 VIEWING HTP OUTPUT ............................................................................................................24
4.10 DEBUGGING..............................................................................................................................24
4.11 TRACING EXECUTION...............................................................................................................27
4.12 REGRESSION TESTING ..............................................................................................................28
5. OPTIMIZING.................................................................................................................................. 29
5.1 USING THE EXPLAIN PLAN WINDOW......................................................................................29
5.2 AUTOMATIC STATISTICS ..........................................................................................................30
5.3 THE PL/SQL PROFILER ........................................................................................................... 31
5.4 SQL TRACE ..............................................................................................................................32
6. AD HOC SQL .................................................................................................................................. 34
6.1 USING THE SQL WINDOW ....................................................................................................... 34
6.2 RESULT GRID MANIPULATION ................................................................................................. 35
6.3 QUERY BY EXAMPLE MODE .................................................................................................... 39
6.4 LINKED QUERIES......................................................................................................................40
6.5 SUBSTITUTION VARIABLES ...................................................................................................... 40
6.6 UPDATING THE DATABASE ...................................................................................................... 41
6.7 VIEWING AND EDITING XMLTYPE COLUMNS ...................................................................... 42
6.8 DIRECT QUERY EXPORT .......................................................................................................... 42
6.9 SAVING SQL SCRIPTS..............................................................................................................42
6.10 CREATING STANDARD QUERIES .............................................................................................43
7. THE COMMAND WINDOW....................................................................................................... 44
7.1 ENTERING SQL STATEMENTS AND COMMANDS..................................................................... 44
7.2 DEVELOPING COMMAND FILES................................................................................................45
7.3 SUPPORTED COMMANDS .......................................................................................................... 46
4 PL/SQL Developer 7.1 User’s Guide
8. CREATING AND MODIFYING NON-PL/SQL OBJECTS ...................................................49
8.1 THE TABLE DEFINITION EDITOR ...............................................................................................49
8.2 THE SEQUENCE DEFINITION EDITOR ........................................................................................60
8.3 THE SYNONYM DEFINITION EDITOR.........................................................................................60
8.4 THE LIBRARY DEFINITION EDITOR ...........................................................................................61
8.5 THE DIRECTORY DEFINITION EDITOR.......................................................................................61
8.6 THE JOB DEFINITION EDITOR ....................................................................................................62
8.7 THE QUEUE DEFINITION EDITOR...............................................................................................62
8.8 THE QUEUE TABLE DEFINITION EDITOR...................................................................................63
8.9 THE USER DEFINITION EDITOR .................................................................................................64
8.10 THE ROLE DEFINITION EDITOR .................................................................................................67
8.11 THE PROFILE DEFINITION EDITOR ............................................................................................68
8.12 THE DATABASE LINK DEFINITION EDITOR ...............................................................................68
9. DIAGRAMS......................................................................................................................................69
9.1 CREATING A DIAGRAM .............................................................................................................69
9.2 SAVING AND OPENING A DIAGRAM FILE..................................................................................71
9.3 UPDATING A DIAGRAM .............................................................................................................71
10. REPORTS .........................................................................................................................................72
10.1 STANDARD REPORTS.................................................................................................................72
10.2 CUSTOM REPORTS .....................................................................................................................73
10.3 VARIABLES................................................................................................................................74
10.4 REFINING THE LAYOUT.............................................................................................................77
10.5 THE STYLE LIBRARY ................................................................................................................84
10.6 OPTIONS ....................................................................................................................................84
10.7 THE REPORTS MENU .................................................................................................................86
11. GRAPHICS.......................................................................................................................................87
12. PROJECTS .......................................................................................................................................89
12.1 CREATING A NEW PROJECT.......................................................................................................89
12.2 SAVING A PROJECT....................................................................................................................89
12.3 ADDING FILES TO A PROJECT....................................................................................................90
12.4 ADDING DATABASE OBJECTS TO A PROJECT ...........................................................................90
12.5 WORKING WITH PROJECT ITEMS ..............................................................................................90
12.6 COMPILING A PROJECT .............................................................................................................91
13. TO-DO ITEMS.................................................................................................................................92
13.1 CREATING A TO-DO ITEM ........................................................................................................93
13.2 EDITING A TO-DO ITEM............................................................................................................93
13.3 CLOSING A TO-DO ITEM...........................................................................................................94
13.4 DELETING A TO-DO ITEM.........................................................................................................94
14. WINDOWS, DATABASE SESSIONS AND TRANSACTIONS .............................................95
14.1 SESSION MODE ..........................................................................................................................95
14.2 EXECUTION IN MULTI SESSION OR DUAL SESSION MODE ......................................................95
15. BROWSING OBJECTS .................................................................................................................96
15.1 USING THE BROWSER ...............................................................................................................96
15.2 BROWSER FILTERS.................................................................................................................101
15.3 BROWSER FOLDERS ...............................................................................................................102
16. PREFERENCES ...........................................................................................................................104
16.1 ORACLE – CONNECTION........................................................................................................ 105
16.2 ORACLE – OPTIONS ...............................................................................................................106
16.3 ORACLE – DEBUGGER ........................................................................................................... 107
PL/SQL Developer 7.1 User’s Guide 5
16.4 ORACLE – OUTPUT.................................................................................................................108
16.5 ORACLE – TRACE ...................................................................................................................109
16.6 ORACLE – PROFILER ..............................................................................................................109
16.7 ORACLE – LOGON HISTORY .................................................................................................. 110
16.8 ORACLE – HINTS ....................................................................................................................111
16.9 USER INTERFACE – OPTIONS................................................................................................. 113
16.10 USER INTERFACE – TOOLBAR ...............................................................................................115
16.11 USER INTERFACE – BROWSER...............................................................................................115
16.12 USER INTERFACE – EDITOR................................................................................................... 117
16.13 USER INTERFACE – FONTS..................................................................................................... 120
16.14 USER INTERFACE – CODE ASSISTANT ..................................................................................121
16.15 USER INTERFACE – KEY CONFIGURATION ...........................................................................122
16.16 USER INTERFACE – APPEARANCE .........................................................................................123
16.17 USER INTERFACE – DATE/TIME ............................................................................................124
16.18 WINDOW TYPES – PROGRAM WINDOW................................................................................125
16.19 WINDOW TYPES – SQL WINDOW .........................................................................................127
16.20 WINDOW TYPES – TEST WINDOW ........................................................................................129
16.21 WINDOW TYPES – PLAN WINDOW........................................................................................129
16.22 TOOLS – DIFFERENCES ..........................................................................................................129
16.23 TOOLS – DATA GENERATOR ................................................................................................. 130
16.24 TOOLS – TO-DO LIST .............................................................................................................131
16.25 TOOLS – RECALL STATEMENT ..............................................................................................131
16.26 FILES – DIRECTORIES.............................................................................................................132
16.27 FILES – EXTENSIONS..............................................................................................................133
16.28 FILES – FORMAT.....................................................................................................................134
16.29 FILES – BACKUP .....................................................................................................................134
16.30 FILES – HTML/XML .............................................................................................................135
16.31 OTHER – PRINTING.................................................................................................................136
16.32 OTHER – UPDATES & NEWS .................................................................................................. 137
16.33 PREFERENCE SETS..................................................................................................................138
17. TOOLS............................................................................................................................................140
17.1 BROWSER................................................................................................................................140
17.2 FIND DATABASE OBJECTS ..................................................................................................... 140
17.3 COMPILE INVALID OBJECTS .................................................................................................. 141
17.4 EXPORT TABLES.....................................................................................................................142
17.5 IMPORT TABLES .....................................................................................................................145
17.6 EXPORT USER OBJECTS .........................................................................................................147
17.7 TEXT IMPORTER .....................................................................................................................148
17.8 ODBC IMPORTER...................................................................................................................151
17.9 DATA GENERATOR.................................................................................................................153
17.10 COMPARE USER OBJECTS ...................................................................................................... 156
17.11 COMPARE TABLE DATA.........................................................................................................158
17.12 EVENT MONITOR....................................................................................................................160
17.13 SESSIONS ................................................................................................................................161
17.14 USER DEFINED TOOLS ...........................................................................................................163
17.15 TEST MANAGER .....................................................................................................................167
18. THE EDITOR ................................................................................................................................170
18.1 SELECTION FUNCTIONS..........................................................................................................170
18.2 COLUMN SELECTION ..............................................................................................................170
18.3 CODE ASSISTANT ...................................................................................................................171
18.4 RECALLING STATEMENTS ......................................................................................................172
18.5 SPECIAL COPY ........................................................................................................................172

资源文件列表:

plsqls1.zip 大约有34个文件
  1. plsql/
  2. plsql/plsql/
  3. plsql/plsql/chinese.exe 2.73MB
  4. plsql/plsql/plsqldev715.1399.exe 15.93MB
  5. plsql/read me.txt 159B
  6. plsql/覆盖的文件/
  7. plsql/覆盖的文件/AfterConnect.sql
  8. plsql/覆盖的文件/BeautifierPreview.cfg 1.94KB
  9. plsql/覆盖的文件/License.rtf 11.72KB
  10. plsql/覆盖的文件/Login.sql 34B
  11. plsql/覆盖的文件/Manual.pdf 4.82MB
  12. plsql/覆盖的文件/OracleDocumentation.html 1.98KB
  13. plsql/覆盖的文件/PlSqlDev.exe 4.22MB
  14. plsql/覆盖的文件/PlSqlDev.exe.manifest 870B
  15. plsql/覆盖的文件/PlanDesc.cfg 2.84KB
  16. plsql/覆盖的文件/Policies.cfg 212B
  17. plsql/覆盖的文件/Preferences/
  18. plsql/覆盖的文件/Preferences/Administrator/
  19. plsql/覆盖的文件/Preferences/Administrator/default.ini 1.42KB
  20. plsql/覆盖的文件/Preferences/Administrator/user.prefs 4.29KB
  21. plsql/覆盖的文件/ReportStyles.lib 1.49KB
  22. plsql/覆盖的文件/WhatsNew.txt 12.79KB
  23. plsql/覆盖的文件/aalf.dat 2KB
  24. plsql/覆盖的文件/aapf.dll 431.78KB
  25. plsql/覆盖的文件/chinese.lang 502.82KB
  26. plsql/覆盖的文件/default.dat 165B
  27. plsql/覆盖的文件/default.kwf 8.18KB
  28. plsql/覆盖的文件/install.txt 2.25KB
  29. plsql/覆盖的文件/params.ini 1.16KB
  30. plsql/覆盖的文件/plsqldev.chm 4.99MB
  31. plsql/覆盖的文件/plsqldev.hlp.id 6.39KB
  32. plsql/覆盖的文件/sqlnet.log 13.52KB
  33. plsql/覆盖的文件/uninstall.ini 87.76KB
  34. plsql/覆盖的文件.zip 14MB
0评论
提交 加载更多评论
其他资源 趣味项目：UI 复现微信官网首页
趣味项目：UI 复现微信官网首页的全部源码，可解压后安装依赖直接运行
 makefile xuexi
makefile xuexi
五子棋五子棋五子棋 五子棋五子棋五子棋
五子棋五子棋五子棋
helloworld+技术实现
helloworld+技术实现
 新天龙八部万能多开器v2.1
免费使用，只能在经典服多开使用，亲测可以用，只能多开用，没有其他本的功能。 号多可以考虑购买小蜜脚本。
 昆仑通泰暖通空调中央空调控制组态程序，适用于绝大多数西门子方案暖通空调自控系统
昆仑通泰暖通空调中央空调控制组态程序，适用于绝大多数西门子方案暖通空调自控系统
Qt联合海康威视工业相机采集，在线转Halcon变量并显示（独立封装、支持多相机、支持黑白相机和彩色相机）
Qt联合海康威视工业相机采集，在线转Halcon变量并显示（独立封装、支持多相机、支持黑白相机和彩色相机）。
永磁同步电机矢量控制C代码，全部从项目中总结得到，采用的S-function模式仿真，与实际项目运行基本一致，可以直接复制代码移
永磁同步电机矢量控制C代码，全部从项目中总结得到，采用的S-function模式仿真，与实际项目运行基本一致，可以直接复制代码移植到工程实践项目中去
本站由星云主机提供云计算服务

网站建设一条龙服务、小程序开发、企业网站建设、定制开发，网络安全检测与维护 业务合作联系QQ:九六九五七三七