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.	LOGGING ON TO AN ORACLE DATABASE	15
4.	WRITING PROGRAMS	16
4.1	CREATING A PROGRAM	16
4.2	SAVING A PROGRAM	17
4.3	MODIFYING A PROGRAM	18
4.4	COMPILING A PROGRAM	18
4.5	COMPARING A PROGRAM	19
4.6	COMPILER PREFERENCES	20
5.	TESTING PROGRAMS	21
5.1	CREATING A TEST SCRIPT	21
5.2	EXECUTING A TEST SCRIPT	22
5.3	VARIABLE TYPES	23
5.4	SAVING TEST SCRIPTS	23
5.5	TRACKING RUN-TIME ERRORS	25
5.6	PACKAGE STATES & JAVA SESSION STATES	25
5.7	VIEWING RESULT SETS	25
5.8	VIEWING DBMS_OUTPUT	25
5.9	VIEWING HTP OUTPUT	26
5.10	DEBUGGING	26
5.11	TRACING EXECUTION	30
5.12	REGRESSION TESTING	31
6.	OPTIMIZING	32
6.1	USING THE EXPLAIN PLAN WINDOW	32
6.2	AUTOMATIC STATISTICS	33
6.3	THE PL/SQL PROFILER	34
6.4	SQL TRACE	35
7.	AD HOC SQL	37
7.1	USING THE SQL WINDOW	37
7.2	RESULT GRID MANIPULATION	39
7.3	QUERY BY EXAMPLE MODE	43
7.4	LINKED QUERIES	44
7.5	SUBSTITUTION VARIABLES	45
7.6	UPDATING THE DATABASE	46
7.7	VIEWING AND EDITING XMLTYPE COLUMNS	47
7.8	COMPARING RECORDS	47
7.9	DIRECT QUERY EXPORT	48
7.10	COMMENT DIRECTIVES	48
7.11	SAVING SQL SCRIPTS	49
7.12	CREATING STANDARD QUERIES	49
8.	THE COMMAND WINDOW	51
8.1	ENTERING SQL STATEMENTS AND COMMANDS	51
8.2	DEVELOPING COMMAND FILES	52
8.3	SUPPORTED COMMANDS	53
9.	CREATING AND MODIFYING NON-PL/SQL OBJECTS	56
9.1	THE TABLE DEFINITION EDITOR	56
9.2	THE SEQUENCE DEFINITION EDITOR	70
9.3	THE SYNONYM DEFINITION EDITOR	70
9.4	THE LIBRARY DEFINITION EDITOR	71
9.5	THE DIRECTORY DEFINITION EDITOR	71
9.6	THE JOB DEFINITION EDITOR	72
9.7	THE QUEUE DEFINITION EDITOR	72
9.8	THE QUEUE TABLE DEFINITION EDITOR	73
9.9	THE USER DEFINITION EDITOR	74
9.10	THE ROLE DEFINITION EDITOR	77
9.11	THE PROFILE DEFINITION EDITOR	78
9.12	THE DATABASE LINK DEFINITION EDITOR	78
10.	DBMS SCHEDULER	79
10.1	CREATING OBJECTS	85
10.2	EDITING OBJECTS	85
10.3	DELETING OBJECTS	85
10.4	VIEWING JOB RUNS	85
10.5	VIEWING RUNNING JOBS	86
11.	DIAGRAMS	87
11.1	CREATING A DIAGRAM	87
11.2	ZOOMING	91
11.3	SAVING AND OPENING A DIAGRAM FILE	91
11.4	UPDATING A DIAGRAM	91
11.5	PRINTING A DIAGRAM	91
11.6	EXPORTING A DIAGRAM	91
12.	REPORTS	92
12.1	STANDARD REPORTS	92
12.2	CUSTOM REPORTS	93
12.3	VARIABLES	94
12.4	REFINING THE LAYOUT	98
12.5	THE STYLE LIBRARY	105
12.6	OPTIONS	105
12.7	THE REPORTS MENU	107
13.	GRAPHICS	108
14.	PROJECTS	110
14.1	CREATING A NEW PROJECT	110
14.2	SAVING A PROJECT	111
14.3	ADDING FILES TO A PROJECT	111
14.4	ADDING DATABASE OBJECTS TO A PROJECT	111
14.5	WORKING WITH PROJECT ITEMS	112
14.6	COMPILING A PROJECT	113
15.	TO-DO ITEMS	114
15.1	CREATING A TO-DO ITEM	115
15.2	EDITING A TO-DO ITEM	115
15.3	CLOSING A TO-DO ITEM	116
15.4	DELETING A TO-DO ITEM	116
16.	THE CONNECTION LIST	117
16.1	USING THE CONNECTION LIST	117
16.2	DEFINING FOLDERS AND CONNECTIONS	120
17.	CONNECTIONS, WINDOWS, SESSIONS AND TRANSACTIONS	123
17.1	THE MAIN CONNECTION	123
17.2	WINDOW CONNECTIONS	123
17.3	SESSION MODE	124
17.4	EXECUTION IN MULTI SESSION OR DUAL SESSION MODE	124
18.	BROWSING OBJECTS	125
18.1	USING THE OBJECT BROWSER	125
18.2	OBJECT BROWSER FILTERS	132
18.3	OBJECT BROWSER FOLDERS	133
19.	BROWSING FILES	135
19.1	SETTING UP THE FILE BROWSER	136
19.2	USING THE FILE BROWSER	137
20.	PREFERENCES	138
20.1	ORACLE – CONNECTION	139
20.2	ORACLE – OPTIONS	140
20.3	ORACLE – COMPILER	142
20.4	ORACLE – DEBUGGER	143
20.5	ORACLE – OUTPUT	144
20.6	ORACLE – TRACE	145
20.7	ORACLE – PROFILER	145
20.8	ORACLE – LOGON HISTORY	147
20.9	ORACLE – HINTS	148
20.10	USER INTERFACE – OPTIONS	150
20.11	USER INTERFACE – OBJECT BROWSER	152
20.12	USER INTERFACE – EDITOR	153
20.13	USER INTERFACE – FONTS	157
20.14	USER INTERFACE – CODE ASSISTANT	158
20.15	USER INTERFACE – KEY CONFIGURATION	159
20.16	USER INTERFACE – APPEARANCE	160
20.17	USER INTERFACE – NLS OPTIONS	162
20.18	WINDOW TYPES – PROGRAM WINDOW	163
20.19	WINDOW TYPES – SQL WINDOW	165
20.20	WINDOW TYPES – TEST WINDOW	168
20.21	WINDOW TYPES – PLAN WINDOW	168
20.22	TOOLS – DIFFERENCES	168
20.23	TOOLS – DATA GENERATOR	169
20.24	TOOLS – TO-DO LIST	170
20.25	TOOLS – RECALL STATEMENT	170
20.26	FILES – DIRECTORIES	171
20.27	FILES – EXTENSIONS	173
20.28	FILES – FORMAT	174
20.29	FILES – BACKUP	175
20.30	FILES – HTML/XML	176
20.31	OTHER – PRINTING	177
20.32	OTHER – UPDATES & NEWS	178
20.33	PREFERENCE SETS	179
21.	TOOLS	181
21.1	OBJECT BROWSER	181
21.2	FIND DATABASE OBJECTS	181
21.3	COMPILE INVALID OBJECTS	182
21.4	EXPORT TABLES	183
21.5	IMPORT TABLES	186
21.6	EXPORT USER OBJECTS	188
21.7	TEXT IMPORTER	189
21.8	ODBC IMPORTER	192
21.9	DATA GENERATOR	194
21.10	COMPARE USER OBJECTS	198
21.11	COMPARE TABLE DATA	200
21.12	EVENT MONITOR	202
21.13	SESSIONS	203
21.14	USER DEFINED TOOLS	205
21.15	TEST MANAGER	209
22.	THE EDITOR	213
22.1	SELECTION FUNCTIONS	213
22.2	COLUMN SELECTION	213
22.3	CODE ASSISTANT	214
22.4	RECALLING STATEMENTS	215
22.5	SPECIAL COPY	216
22.6	PASTE FROM HOST LANGUAGE	217
22.7	CONTEXT SENSITIVE HELP	218
22.8	DATABASE OBJECT POPUP MENU	218
22.9	EXPLAIN PLAN	218
22.10	MACROS	218
22.11	BOOKMARKS	219
22.12	COLOR MARKS	220
22.13	CODE CONTENTS	221
22.14	CODE HIERARCHY	222
22.15	CODE FOLDING	223
22.16	SPLIT EDITING	223
22.17	HYPERLINK NAVIGATION	224
22.18	NAVIGATION BUTTONS	224
22.19	REFACTORING	225
22.20	SEARCH BAR	225
22.21	WEB SEARCH	227
23.	THE LARGE DATA EDITOR	229
23.1	EDITING PLAIN TEXT	230
23.2	EDITING RTF	230
23.3	EDITING XML	231
23.4	EDITING HTML	232
23.5	EDITING IMAGES	232
23.6	EDITING HEX DATA	232
23.7	INVOKING AN EXTERNAL VIEWER OR EDITOR	233
24.	THE QUERY BUILDER	235
24.1	CREATING A NEW SELECT STATEMENT	235
24.2	MODIFYING AN EXISTING SELECT STATEMENT	238
24.3	MANIPULATING THE QUERY DEFINITION	238
24.4	QUERY BUILDER PREFERENCES	239
24.5	QUERY BUILDER PLUG-INS	240
25.	THE PL/SQL BEAUTIFIER	241
25.1	DEFINING THE OPTIONS	241
25.2	DEFINING THE RULES	242
25.3	USING THE BEAUTIFIER	243
25.4	SUPPRESSING FORMATTING	243
26.	TEMPLATES	244
26.1	THE TEMPLATE WINDOW	244
26.2	USING A TEMPLATE	245
26.3	CREATING AND MODIFYING TEMPLATES	246
27.	WINDOW LIST	249
28.	DOCKABLE AND FLOATING TOOLS	250
29.	TOOLBARS	252
30.	AUTHORIZATION	255
30.1	ENABLING AUTHORIZATION	255
30.2	DEFINING AUTHORIZATION	256
30.3	DISABLING AUTHORIZATION	257
31.	ORACLE FILE SYSTEM (OFS)	258
31.1	OFS MANAGER	258
31.2	OFS USAGE	260
32.	HELP SYSTEMS	262
32.1	MS HELP FILES	262
32.2	HTML MANUALS	262
33.	CUSTOMIZATION	266
33.1	PREFERENCES	266
33.2	WINDOW LAYOUT	266
33.3	ON-LINE DOCUMENTATION	266
33.4	COMMAND-LINE PARAMETERS	268
33.5	SQL, PL/SQL AND COMMAND KEYWORDS	271
33.6	PLUG-INS	271