4 PL/SQL Developer 12.0 User’s Guide
8. THE COMMAND WINDOW................................................................................................. 51
8.1 ENTERING SQL STATEMENTS AND COMMANDS ................................................................ 51
8.2 D
EVELOPING COMMAND FILES
.......................................................................................... 52
8.3 SUPPORTED COMMANDS.................................................................................................... 52
9. CREATING AND MODIFYING NON-PL/SQL OBJECTS................................................ 56
9.1 T
HE TABLE DEFINITION EDITOR
......................................................................................... 56
9.2 THE SEQUENCE DEFINITION EDITOR .................................................................................. 69
9.3 T
HE SYNONYM DEFINITION EDITOR
................................................................................... 69
9.4 THE LIBRARY DEFINITION EDITOR ..................................................................................... 70
9.5 T
HE DIRECTORY DEFINITION EDITOR
................................................................................. 70
9.6 THE JOB DEFINITION EDITOR ............................................................................................. 71
9.7 T
HE QUEUE DEFINITION EDITOR
........................................................................................ 71
9.8 T
HE QUEUE TABLE DEFINITION EDITOR
............................................................................. 72
9.9 T
HE USER DEFINITION EDITOR
........................................................................................... 73
9.10 T
HE ROLE DEFINITION EDITOR
........................................................................................... 76
9.11 T
HE PROFILE DEFINITION EDITOR
...................................................................................... 76
9.12 THE DATABASE LINK DEFINITION EDITOR.......................................................................... 77
10. DBMS SCHEDULER .............................................................................................................. 78
10.1 C
REATING OBJECTS
........................................................................................................... 85
10.2 E
DITING OBJECTS
.............................................................................................................. 85
10.3 D
ELETING OBJECTS
........................................................................................................... 85
10.4 V
IEWING JOB RUNS
........................................................................................................... 85
10.5 V
IEWING RUNNING JOBS
.................................................................................................... 86
11. DIAGRAMS ............................................................................................................................. 87
11.1 C
REATING A DIAGRAM
...................................................................................................... 87
11.2 Z
OOMING
.......................................................................................................................... 90
11.3 SAVING AND OPENING A DIAGRAM FILE ............................................................................ 90
11.4 U
PDATING A DIAGRAM
...................................................................................................... 90
11.5 PRINTING A DIAGRAM ....................................................................................................... 91
11.6 E
XPORTING A DIAGRAM
.................................................................................................... 91
12. REPORTS ................................................................................................................................ 92
12.1 STANDARD REPORTS ......................................................................................................... 92
12.2 C
USTOM REPORTS
............................................................................................................. 93
12.3 VARIABLES ....................................................................................................................... 93
12.4 R
EFINING THE LAYOUT
...................................................................................................... 98
12.5 THE STYLE LIBRARY....................................................................................................... 104
12.6 O
PTIONS
.......................................................................................................................... 105
12.7 T
HE
R
EPORTS MENU
........................................................................................................ 106
13. GRAPHICS ............................................................................................................................ 108
14. PROJECTS ............................................................................................................................ 110
14.1 C
REATING A NEW PROJECT
.............................................................................................. 110
14.2 SAVING A PROJECT .......................................................................................................... 111
14.3 A
DDING FILES TO A PROJECT
........................................................................................... 111
14.4 A
DDING DATABASE OBJECTS TO A PROJECT
.................................................................... 111
14.5 W
ORKING WITH PROJECT ITEMS
...................................................................................... 112
14.6 COMPILING A PROJECT .................................................................................................... 113
15. TO-DO ITEMS ...................................................................................................................... 114
15.1 C
REATING A
T
O
-D
O
I
TEM
............................................................................................... 115
15.2 EDITING A TO-DO ITEM................................................................................................... 115
15.3 C
LOSING A
T
O
-D
O
I
TEM
.................................................................................................. 115
