求PL/SQL DEVELOPER 使用文档 求PL/SQL DEVELOPER 使用文档 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 安装好程序后进入程序help-->User’s Guide(ms word)图文并茂,什么都有了!贴一个目录先ContentsCONTENTS 31. INTRODUCTION 72. INSTALLATION 102.1 SYSTEM REQUIREMENTS 102.2 WORKSTATION INSTALLATION 102.3 SERVER INSTALLATION 102.4 UNINSTALLING PL/SQL DEVELOPER 103. WRITING PROGRAMS 113.1 CREATING A PROGRAM 113.2 SAVING A PROGRAM 123.3 MODIFYING A PROGRAM 133.4 COMPILING A PROGRAM 134. TESTING PROGRAMS 154.1 CREATING A TEST SCRIPT 154.2 EXECUTING A TEST SCRIPT 164.3 VARIABLE TYPES 174.4 SAVING TEST SCRIPTS 184.5 TRACKING RUN-TIME ERRORS 194.6 PACKAGE STATES & JAVA SESSION STATES 194.7 VIEWING RESULT SETS 194.8 VIEWING DBMS_OUTPUT 194.9 VIEWING HTP OUTPUT 204.10 DEBUGGING 204.11 TRACING EXECUTION 235. OPTIMIZING 255.1 USING THE EXPLAIN PLAN WINDOW 255.2 AUTOMATIC STATISTICS 265.3 THE PL/SQL PROFILER 275.4 SQL TRACE 286. AD HOC SQL 306.1 USING THE SQL WINDOW 306.2 RESULT GRID MANIPULATION 316.3 QUERY BY EXAMPLE MODE 356.4 LINKED QUERIES 366.5 SUBSTITUTION VARIABLES 366.6 UPDATING THE DATABASE 376.7 VIEWING AND EDITING XMLTYPE COLUMNS 386.8 DIRECT QUERY EXPORT 386.9 SAVING SQL SCRIPTS 387. THE COMMAND WINDOW 397.1 ENTERING SQL STATEMENTS AND COMMANDS 397.2 DEVELOPING COMMAND FILES 407.3 SUPPORTED COMMANDS 418. CREATING AND MODIFYING NON-PL/SQL OBJECTS 438.1 THE TABLE DEFINITION EDITOR 438.2 THE SEQUENCE DEFINITION EDITOR 538.3 THE SYNONYM DEFINITION EDITOR 538.4 THE LIBRARY DEFINITION EDITOR 548.5 THE DIRECTORY DEFINITION EDITOR 548.6 THE JOB DEFINITION EDITOR 558.7 THE USER DEFINITION EDITOR 558.8 THE ROLE DEFINITION EDITOR 588.9 THE PROFILE DEFINITION EDITOR 598.10 THE DATABASE LINK DEFINITION EDITOR 599. REPORTS 609.1 STANDARD REPORTS 609.2 CUSTOM REPORTS 619.3 VARIABLES 629.4 REFINING THE LAYOUT 669.5 THE STYLE LIBRARY 729.6 OPTIONS 729.7 THE REPORTS MENU 7410. PROJECTS 7510.1 CREATING A NEW PROJECT 7510.2 SAVING A PROJECT 7510.3 ADDING SOURCE FILES TO A PROJECT 7610.4 ADDING DATABASE OBJECTS TO A PROJECT 7610.5 WORKING WITH PROJECT ITEMS 7610.6 COMPILING A PROJECT 7711. WINDOWS, DATABASE SESSIONS AND TRANSACTIONS 7811.1 SESSION MODE 7811.2 EXECUTION IN MULTI SESSION OR DUAL SESSION MODE 7812. BROWSING OBJECTS 7912.1 USING THE BROWSER 7912.2 BROWSER FILTERS 8413. TOOLS 8613.1 PREFERENCES 8613.2 BROWSER 10313.3 FIND DATABASE OBJECTS 10313.4 COMPILE INVALID OBJECTS 10413.5 EXPORT TABLES 10513.6 IMPORT TABLES 10713.7 EXPORT USER OBJECTS 10913.8 COMPARE USER OBJECTS 11013.9 EVENT MONITOR 11113.10 SESSIONS 11213.11 EXTERNAL TOOLS 11314. THE EDITOR 11814.1 SELECTION FUNCTIONS 11814.2 COLUMN SELECTION 11814.3 CODE ASSISTANT 11914.4 RECALLING STATEMENTS 12014.5 SPECIAL COPY 12014.6 CONTEXT SENSITIVE HELP 12114.7 DATABASE OBJECT POPUP MENU 12114.8 EXPLAIN PLAN 12114.9 MACROS 12114.10 CODE CONTENTS 12314.11 HYPERLINK NAVIGATION 12314.12 BROWSE BUTTONS 12415. THE QUERY BUILDER 12515.1 CREATING A NEW SELECT STATEMENT 12515.2 MODIFYING AN EXISTING SELECT STATEMENT 12815.3 MANIPULATING THE QUERY DEFINITION 12815.4 QUERY BUILDER PREFERENCES 12916. THE PL/SQL BEAUTIFIER 13116.1 DEFINING THE OPTIONS 13116.2 DEFINING THE RULES 13216.3 USING THE BEAUTIFIER 13317. TEMPLATES 13417.1 THE TEMPLATE WINDOW 13417.2 USING A TEMPLATE 13517.3 CREATING AND MODIFYING TEMPLATES 13618. WINDOW LIST 14119. HELP SYSTEMS 14219.1 MS HELP FILES 14219.2 HTML MANUALS 14220. CUSTOMIZATION 14520.1 PREFERENCES 14520.2 WINDOW LAYOUT 14520.3 ON-LINE DOCUMENTATION 14520.4 LOGON HISTORY 14720.5 COMMAND-LINE PARAMETERS 14820.6 SQL, PL/SQL, COMMAND, JAVA AND XML KEYWORDS 14920.7 PLUG-INS 149 我想要中文的使用手册!!!!!!!!!!!!!!!!!!!!!!!!!!!![email protected] 如果有人能提供Form Builder 和Report Builder 的教材,那样会更好! 安装的时候就用呀,干嘛要呢你到HELP里面,有个WORD的文档 怎么用oracle搭建一个程序 关于表空间的入门概念问题 怎样使用缺少控制文件的备份文件恢复数据库??? 求如何生成这样的随机数 oracle中对于null的处理 在Oracle如何用SQL语句把指定行号之间的记录查询出来 如何确保将一条记录插入表的最后,因为有时插入一条记录时,它会排在表的中间 如何优化这个report builder6i报表的sql查询? 这样的的原始数据,Sql*Loader里的控制文件如何写? 数据合并问题,请各大神指点一下.谢谢 还是老问题,MANAGEMENTSERVER无法启动!急救!! 请问如何把一个表里边的所有列名列出来?
进入程序
help-->User’s Guide(ms word)
图文并茂,什么都有了!贴一个目录先Contents
CONTENTS 3
1. INTRODUCTION 7
2. INSTALLATION 10
2.1 SYSTEM REQUIREMENTS 10
2.2 WORKSTATION INSTALLATION 10
2.3 SERVER INSTALLATION 10
2.4 UNINSTALLING PL/SQL DEVELOPER 10
3. WRITING PROGRAMS 11
3.1 CREATING A PROGRAM 11
3.2 SAVING A PROGRAM 12
3.3 MODIFYING A PROGRAM 13
3.4 COMPILING A PROGRAM 13
4. TESTING PROGRAMS 15
4.1 CREATING A TEST SCRIPT 15
4.2 EXECUTING A TEST SCRIPT 16
4.3 VARIABLE TYPES 17
4.4 SAVING TEST SCRIPTS 18
4.5 TRACKING RUN-TIME ERRORS 19
4.6 PACKAGE STATES & JAVA SESSION STATES 19
4.7 VIEWING RESULT SETS 19
4.8 VIEWING DBMS_OUTPUT 19
4.9 VIEWING HTP OUTPUT 20
4.10 DEBUGGING 20
4.11 TRACING EXECUTION 23
5. OPTIMIZING 25
5.1 USING THE EXPLAIN PLAN WINDOW 25
5.2 AUTOMATIC STATISTICS 26
5.3 THE PL/SQL PROFILER 27
5.4 SQL TRACE 28
6. AD HOC SQL 30
6.1 USING THE SQL WINDOW 30
6.2 RESULT GRID MANIPULATION 31
6.3 QUERY BY EXAMPLE MODE 35
6.4 LINKED QUERIES 36
6.5 SUBSTITUTION VARIABLES 36
6.6 UPDATING THE DATABASE 37
6.7 VIEWING AND EDITING XMLTYPE COLUMNS 38
6.8 DIRECT QUERY EXPORT 38
6.9 SAVING SQL SCRIPTS 38
7. THE COMMAND WINDOW 39
7.1 ENTERING SQL STATEMENTS AND COMMANDS 39
7.2 DEVELOPING COMMAND FILES 40
7.3 SUPPORTED COMMANDS 41
8. CREATING AND MODIFYING NON-PL/SQL OBJECTS 43
8.1 THE TABLE DEFINITION EDITOR 43
8.2 THE SEQUENCE DEFINITION EDITOR 53
8.3 THE SYNONYM DEFINITION EDITOR 53
8.4 THE LIBRARY DEFINITION EDITOR 54
8.5 THE DIRECTORY DEFINITION EDITOR 54
8.6 THE JOB DEFINITION EDITOR 55
8.7 THE USER DEFINITION EDITOR 55
8.8 THE ROLE DEFINITION EDITOR 58
8.9 THE PROFILE DEFINITION EDITOR 59
8.10 THE DATABASE LINK DEFINITION EDITOR 59
9. REPORTS 60
9.1 STANDARD REPORTS 60
9.2 CUSTOM REPORTS 61
9.3 VARIABLES 62
9.4 REFINING THE LAYOUT 66
9.5 THE STYLE LIBRARY 72
9.6 OPTIONS 72
9.7 THE REPORTS MENU 74
10. PROJECTS 75
10.1 CREATING A NEW PROJECT 75
10.2 SAVING A PROJECT 75
10.3 ADDING SOURCE FILES TO A PROJECT 76
10.4 ADDING DATABASE OBJECTS TO A PROJECT 76
10.5 WORKING WITH PROJECT ITEMS 76
10.6 COMPILING A PROJECT 77
11. WINDOWS, DATABASE SESSIONS AND TRANSACTIONS 78
11.1 SESSION MODE 78
11.2 EXECUTION IN MULTI SESSION OR DUAL SESSION MODE 78
12. BROWSING OBJECTS 79
12.1 USING THE BROWSER 79
12.2 BROWSER FILTERS 84
13. TOOLS 86
13.1 PREFERENCES 86
13.2 BROWSER 103
13.3 FIND DATABASE OBJECTS 103
13.4 COMPILE INVALID OBJECTS 104
13.5 EXPORT TABLES 105
13.6 IMPORT TABLES 107
13.7 EXPORT USER OBJECTS 109
13.8 COMPARE USER OBJECTS 110
13.9 EVENT MONITOR 111
13.10 SESSIONS 112
13.11 EXTERNAL TOOLS 113
14. THE EDITOR 118
14.1 SELECTION FUNCTIONS 118
14.2 COLUMN SELECTION 118
14.3 CODE ASSISTANT 119
14.4 RECALLING STATEMENTS 120
14.5 SPECIAL COPY 120
14.6 CONTEXT SENSITIVE HELP 121
14.7 DATABASE OBJECT POPUP MENU 121
14.8 EXPLAIN PLAN 121
14.9 MACROS 121
14.10 CODE CONTENTS 123
14.11 HYPERLINK NAVIGATION 123
14.12 BROWSE BUTTONS 124
15. THE QUERY BUILDER 125
15.1 CREATING A NEW SELECT STATEMENT 125
15.2 MODIFYING AN EXISTING SELECT STATEMENT 128
15.3 MANIPULATING THE QUERY DEFINITION 128
15.4 QUERY BUILDER PREFERENCES 129
16. THE PL/SQL BEAUTIFIER 131
16.1 DEFINING THE OPTIONS 131
16.2 DEFINING THE RULES 132
16.3 USING THE BEAUTIFIER 133
17. TEMPLATES 134
17.1 THE TEMPLATE WINDOW 134
17.2 USING A TEMPLATE 135
17.3 CREATING AND MODIFYING TEMPLATES 136
18. WINDOW LIST 141
19. HELP SYSTEMS 142
19.1 MS HELP FILES 142
19.2 HTML MANUALS 142
20. CUSTOMIZATION 145
20.1 PREFERENCES 145
20.2 WINDOW LAYOUT 145
20.3 ON-LINE DOCUMENTATION 145
20.4 LOGON HISTORY 147
20.5 COMMAND-LINE PARAMETERS 148
20.6 SQL, PL/SQL, COMMAND, JAVA AND XML KEYWORDS 149
20.7 PLUG-INS 149
[email protected]
你到HELP里面,有个WORD的文档