Oracle9i
: SQL
1
40057CN11
1.1
2002 2
D34367
© Oracle
2001
Oracle
!"#$ %&
'()*+,-./0123
45 Oracle 6789:;<=>
?@ABCDE BCFGH
IBCJK
45 Oracle =>;<LHMHNOPQR
ST!-P QUVWXYZY[B
I'\]^_ `?a-bc defgIhijBCk
l m=>bc Worldwide Education Services, Oracle Corporation, 500
Oracle Parkway, Box SB-6, Redwood Shores, CA 94065
Oracle ?#
Ihnop
Oracle A) Oracle 89qOP Oracle rsMturs
'vw89Mxyz{s|} ~vw'Urs
Nancy Greenberg
Priya Nathan
Josephine Turner
Martin Alvarez
Anna Atkinson
Don Bates
Marco Berbeek
Andrew Brannigan
Laszlo Czinkoczki
Michael Gerlach
Sharon Gray
Rosita Hanoman
Mozhe Jalali
Sarah Jones
Charbel Khouri
Christopher Lawless
Diana Lorentz
Nina Minchen
Cuong Nguyen
Daphne Nougier
Patrick Odell
Laura Pezzini
Stacey Procter
Maribel Renau
Bryan Roberts
Helen Robertson
Sunshine Salmon
Casa Sharif
Bernard Soleillant
Craig Spoonemore
Ruediger Steffan
Karla Villasenor
Andree Wheeley
Lachlan Williams
Nita Brozowski
Curriculum Map
I-2
Oracle9i I-3
Oracle9i Application Server I-5
Oracle9i Database I-6
I-7
Oracle Internet Platform I-8
I-9
I-11
I-12
! I-13
"# I-14
$%"# I-15
$%&"'( I-16
)*+,-./ I-18
01 I-19
23 I-20
4 SQL 5 RDBMS 67 I-21
I-22
SQL 18 I-23
9:;4, I-24
<= I-25
> 1 9
99
9
?@AB
?@AB?@AB
?@AB SQL SELECT 18
1818
18
1-2
SQL SELECT 18CD 1-3
AB SELECT 18 1-4
EFGHI 1-5
EF2 I 1-6
?@ SQL 18 1-7
IJKLM 1-8
N0,OP 1-9
4N0QNR 1-10
QNRSTUV 1-11
4WX 1-13
!YM 1-14
N0,OP;YM 1-15
!IZ[ 1-16
4IZ[ 1-17
\]QNR 1-18
iii
4\]QNR 1-19
^__R` 1-20
4^__R` 1-21
abc 1-22
deabc 1-23
SQL iSQL*Plus fg 1-24
SQL 185 iSQL*Plushi 1-25
iSQL*Plus j 1-26
klm iSQL*Plus 1-27
iSQL*Plus no 1-28
pq,=r 1-29
5sB^tfg 1-31
<= 1-34
uv 1 j 1-35
>
>>
> 2 9
99
9
wxyV
wxyVwxyV
wxyV
2-2
4EFCDwxc 2-3
wxE c 2-4
4 WHERE z8 2-5
_R`{ 2-6
|}~t 2-7
4|}~t 2-8
|}~t 2-9
4 BETWEEN ~t 2-10
4 IN ~t 2-11
4 LIKE ~t 2-12
4 NULL ~t 2-14
~t 2-15
4 AND QNR 2-16
4 OR QNR 2-17
4 NOT QNR 2-18
STUV 2-19
ORDER BY z8 2-22
VyV 2-23
IZ[yV 2-24
*+IcyV 2-25
<= 2-26
uv 2 j 2-27
>
>>
> 3 9
99
9
c
cc
c
3-2
SQL 3-3
SQL # 3-4
c 3-5
_R 3-7
<@ 3-9
iv
4<@ 3-10
_R 3-11
4_R 3-12
_ 3-13
4 ROUND 3-14
4 TRUNC 3-15
4 MOD 3-16
{ 3-17
5{HQN 3-19
4N0QNR{ 3-20
{ 3-21
4{ 3-22
uv 3
> 1 j 3-24
3-25
P# 3-26
pP# 3-28
4 TO_CHAR { 3-31
{PP 3-32
4 TO_CHAR { 3-36
4 TO_CHAR _ 3-37
4 TO_NUMBER TO_DATE 3-39
RR {P 3-41
RR {Pq( 3-42
3-43
3-45
NVL 3-46
4 NVL 3-47
4 NVL2 3-48
4 NULLIF 3-49
4 COALESCE 3-50
~t,OP 3-52
CASE ,OP 3-53
4 CASE ,OP 3-54
DECODE 3-55
4 DECODE 3-56
<= 3-58
uv 3
> 2 j 3-59
>
>>
> 4 9
99
9
pq*+,;
pq*+,;pq*+,;
pq*+,;
4-2
*+,; 4-3
¡ 4-4
¢£¡ 4-5
-=# 4-6
4 Oracle 1¤),-=./ 4-7
¥¦§¨M-=
4-8
6©¨M-=ª«¬l 4-9
v
