4 PL/SQL Developer 14.0 User’s Guide
7.13
C
REATING
S
TANDARD
Q
UERIES
........................................................................................ 52
8.
THE COMMAND WINDOW ................................................................................................. 54
8.1
E
NTERING
SQL
STATEMENTS AND COMMANDS
................................................................ 54
8.2
D
EVELOPING COMMAND FILES
.......................................................................................... 55
8.3
S
UPPORTED COMMANDS
.................................................................................................... 55
8.4
E
XPORT
T
ABLES COMMAND SYNTAX
................................................................................ 58
8.5
E
XPORT
O
BJECTS COMMAND SYNTAX
............................................................................... 59
9.
CREATING AND MODIFYING NON-PL/SQL OBJECTS ................................................ 60
9.1
T
HE TABLE DEFINITION EDITOR
......................................................................................... 60
9.2
T
HE SEQUENCE DEFINITION EDITOR
.................................................................................. 73
9.3
T
HE SYNONYM DEFINITION EDITOR
................................................................................... 73
9.4
T
HE LIBRARY DEFINITION EDITOR
..................................................................................... 74
9.5
T
HE DIRECTORY DEFINITION EDITOR
................................................................................. 74
9.6
T
HE JOB DEFINITION EDITOR
............................................................................................. 75
9.7
T
HE QUEUE DEFINITION EDITOR
........................................................................................ 75
9.8
T
HE QUEUE TABLE DEFINITION EDITOR
............................................................................. 76
9.9
T
HE USER DEFINITION EDITOR
........................................................................................... 77
9.10
T
HE ROLE DEFINITION EDITOR
........................................................................................... 80
9.11
T
HE PROFILE DEFINITION EDITOR
...................................................................................... 80
9.12
T
HE DATABASE LINK DEFINITION EDITOR
.......................................................................... 81
10.
DBMS SCHEDULER .............................................................................................................. 82
10.1
C
REATING OBJECTS
........................................................................................................... 89
10.2
EDITING OBJECTS .............................................................................................................. 89
10.3
D
ELETING OBJECTS
........................................................................................................... 89
10.4
V
IEWING JOB RUNS
........................................................................................................... 89
10.5
V
IEWING RUNNING JOBS
.................................................................................................... 90
11.
DIAGRAMS ............................................................................................................................. 91
11.1
C
REATING A DIAGRAM
...................................................................................................... 91
11.2
Z
OOMING
.......................................................................................................................... 94
11.3
S
AVING AND OPENING A DIAGRAM FILE
............................................................................ 94
11.4
U
PDATING A DIAGRAM
...................................................................................................... 94
11.5
P
RINTING A DIAGRAM
....................................................................................................... 95
11.6
E
XPORTING A DIAGRAM
.................................................................................................... 95
12.
REPORTS ................................................................................................................................ 96
12.1
S
TANDARD REPORTS
......................................................................................................... 96
12.2
C
USTOM REPORTS
............................................................................................................. 97
12.3
V
ARIABLES
....................................................................................................................... 97
12.4
R
EFINING THE LAYOUT
.................................................................................................... 102
12.5
T
HE
S
TYLE
L
IBRARY
....................................................................................................... 108
12.6
O
PTIONS
.......................................................................................................................... 109
12.7
T
HE
R
EPORTS MENU
........................................................................................................ 110
13.
GRAPHICS ............................................................................................................................ 112
14.
PROJECTS ............................................................................................................................ 114
14.1
C
REATING A NEW PROJECT
.............................................................................................. 114
14.2
S
AVING A PROJECT
.......................................................................................................... 115
14.3
A
DDING FILES TO A PROJECT
........................................................................................... 115
14.4
A
DDING DATABASE OBJECTS TO A PROJECT
.................................................................... 115
14.5 WORKING WITH PROJECT ITEMS ...................................................................................... 116
14.6
C
OMPILING A PROJECT
.................................................................................................... 117
资源由 ｗｗｗ．ｅｉｍｈｅ．ｃｏｍ 美河学习在线收集分享
