An A-Z Index of Oracle SQL Commands (version 9.2)

51TestingÈí¼þ²âÊÔÍøk;~:P+| a
AUDIT
3a4a$VS$DA
i(DF051TestingÈí¼þ²âÊÔÍø6^;E\sS,^ _v$f
CALL51TestingÈí¼þ²âÊÔÍø?C~kX0?|Z
Cluster - CREATE CLUSTER
[4Nv l%]6U0€€€€€€€€€€€€€€ - ALTER€€ CLUSTER
"V@D6mBj:m)C4_0€€€€€€€€€€€€€€ - DROP€€€€ CLUSTER51TestingÈí¼þ²âÊÔÍø:l*kzz7A No
COMMENT

COMMIT51TestingÈí¼þ²âÊÔÍøq+U_-meu4g8HZ
CONNECT51TestingÈí¼þ²âÊÔÍøT_?0D@5bO:z%[Kk
CONSTRAINT - Add / Enable
'|e*y}*_(S0Context - CREATE CONTEXT51TestingÈí¼þ²âÊÔÍøi8e:ICzRt W3P
€€€€€€€€€€€€€€ - DROP CONTEXT51TestingÈí¼þ²âÊÔÍø(nCset%S
Controlfile - CREATE CONTROLFILE
l.dfC"q(d#Q\7r0
Yu(X\F a0Database - CREATE DATABASE51TestingÈí¼þ²âÊÔÍøEn z]w2K:GK$n;Y/x
€€€€€€€€€€€€€€€€ - ALTER€€ DATABASE51TestingÈí¼þ²âÊÔÍøLsq}]&\%grd'M
DELETE
(yGk'YL0DESCRIBE
o }7O'bnrIpR0Dimension - CREATE DIMENSION51TestingÈí¼þ²âÊÔÍøs2u"`)Bl6j
€€€€€€€€€€€€€€€€€€ - ALTER DIMENSION51TestingÈí¼þ²âÊÔÍøYn Du0S(`
€€€€€€€€€€€€€€€€€€ - DROP DIMENSION51TestingÈí¼þ²âÊÔÍøhW+b|U+b$V
Directory - CREATE DIRECTORY51TestingÈí¼þ²âÊÔÍø3QT{3iN(|
€€€€€€€€€€€€€€€€€€ - DROP DIRECTORY51TestingÈí¼þ²âÊÔÍø.Ga+f'g.o#k
51TestingÈí¼þ²âÊÔÍøT0Cf!S]
y @
EXEC
nYxU`0EXECUTE IMMEDIATE
yn`oFeV0EXPLAIN PLAN
4a llc8R} l0
.r6Y+V2d3BB0Function - CREATE FUNCTION
k]'qU j/@)V0€€€€€€€€€€€€€€€€ - ALTER€€ FUNCTION
$tm_&f!K}gB1q0€€€€€€€€€€€€€€€€ - DROP€€€€ FUNCTION
0] sm3Vt0

m.R(K)u%\ scz0GRANT
*W'PCA+jL051TestingÈí¼þ²âÊÔÍø3\7W c'` g^hD*~
Index - CREATE INDEX
2c9S,x;d"Y6Rs0€€€€€€€€€€ - ALTER€€ INDEX
N[!Bc%au3e;|nvJ0€€€€€€€€€€ - DROP€€€€ INDEX
n&`f`.L6RM0Indextype - CREATE INDEXTYPE51TestingÈí¼þ²âÊÔÍø\9KV}0B H_d
€€€€€€€€€€€€€€€€€€ - DROP INDEXTYPE
?"aWo:vvI0INSERT51TestingÈí¼þ²âÊÔÍøW;@0BHNj8X-U
INTERSECT
KkFu5M051TestingÈí¼þ²âÊÔÍø/a)sv-O8n\ T'}w/?
Java - CREATE JAVA
%Ez H m8\e0€€€€€€€€ - ALTER JAVA51TestingÈí¼þ²âÊÔÍø
eR/~,n:q~
€€€€€€€€ - DROP JAVA51TestingÈí¼þ²âÊÔÍød\9eF.aB
e7|6] |

u.YJq)_3wQ0Library - CREATE LIBRARY
b$~8O7glB0€€€€€€€€€€€€€€ - DROP LIBRARY51TestingÈí¼þ²âÊÔÍøCEG7w`&X9h^
Link - CREATE DATABASE LINK
+w[&LR3V| E0€€€€€€€€ - DROP DATABASE LINK51TestingÈí¼þ²âÊÔÍøkt p5V9?;h
U
LOCK TABLE51TestingÈí¼þ²âÊÔÍøM7qY ~"IP;J
51TestingÈí¼þ²âÊÔÍøm]!of*g
Mview - CREATE MATERIALIZED VIEW51TestingÈí¼þ²âÊÔÍø?D4R*s;L/g7QB
€€€€€€€€€€ - ALTER MATERIALIZED VIEW
&jZvm:{*UQ?p~ L0€€€€€€€€€€ - DROP MATERIALIZED VIEW
}e,kL9\)tt0€€€€€€€€€€ - CREATE MATERIALIZED VIEW LOG
%L;k,wV+yHY&} xK0€€€€€€€€€€ - ALTER MATERIALIZED VIEW LOG51TestingÈí¼þ²âÊÔÍøI%]+A.|1w5A
€€€€€€€€€€ - DROP MATERIALIZED VIEW LOG51TestingÈí¼þ²âÊÔÍø`:{v2Y)h`
MINUS
$~F2uhPw;D0
3Pu;YU,lD0NOAUDIT
6|5w.u$ZaM0
8W&x(GW#zL0Operator - CREATE OPERATOR
f [JR,W,pd0€€€€€€€€€€€€€€€€ - DROP OPERATOR51TestingÈí¼þ²âÊÔÍø7K(^`/U1\m"a!nQ
Outline - CREATE OUTLINE51TestingÈí¼þ²âÊÔÍøJo/F4?!|VM)~-_
€€€€€€€€€€€€€€ - ALTER OUTLINE51TestingÈí¼þ²âÊÔÍøkKM+DK"{(M%ff-c'r
€€€€€€€€€€€€€€ - DROP OUTLINE51TestingÈí¼þ²âÊÔÍø#C3n!h\ Bl
51TestingÈí¼þ²âÊÔÍøT]zJOC
Package - CREATE PACKAGE/BODY
.x8}:gF Wz2O0€€€€€€€€€€€€€€ - ALTER€€ PACKAGE
K|[#Nv;flh0€€€€€€€€€€€€€€ - DROP€€€€ PACKAGE51TestingÈí¼þ²âÊÔÍø.hn(_t~.E
Pfile - CREATE PFILE51TestingÈí¼þ²âÊÔÍøs9G5G-n-V
Procedure - CREATE PROCEDURE
1M5Gfg5p~ka0€€€€€€€€€€€€€€€€€€ - ALTER€€ PROCEDURE51TestingÈí¼þ²âÊÔÍø@$IdE+u}'J
€€€€€€€€€€€€€€€€€€ - DROP€€€€ PROCEDURE
$PkVX(V ?x0Profile - CREATE PROFILE

j A \#{p3aw0€€€€€€€€€€€€€€ - ALTER€€ PROFILE
Lg"o7Y4EK^C1e4K6R0€€€€€€€€€€€€€€ - DROP€€€€ PROFILE51TestingÈí¼þ²âÊÔÍø)m3c J~bi
51TestingÈí¼þ²âÊÔÍø:gVX{6}
RECOVER51TestingÈí¼þ²âÊÔÍø:H$l_,}l+k
RENAME51TestingÈí¼þ²âÊÔÍøX7~6DVC
Resource - ALTER RESOURCE COST
BbN3|8U6HF2j0REVOKE51TestingÈí¼þ²âÊÔÍø7V8D1F2Yip1O/ve
RMAN - Recovery Manager
!?+\?y5P*D(?0Role - CREATE ROLE51TestingÈí¼þ²âÊÔÍøx@-?'J
E(Dk
€€€€€€€€ - SET€€€€€€ ROLE51TestingÈí¼þ²âÊÔÍø|gOd4EH
€€€€€€€€ - ALTER€€ ROLE51TestingÈí¼þ²âÊÔÍø;C8_#bx8b)S#v
€€€€€€€€ - DROP€€€€ ROLE
;vbA8z~/n0ROLLBACK
P%YC+e oE0Rollback - CREATE ROLLBACK SEGMENT51TestingÈí¼þ²âÊÔÍøP
K_#w3oO)E
€€€€€€€€€€€€€€€€ - ALTER€€ ROLLBACK SEGMENT51TestingÈí¼þ²âÊÔÍøRI4J"N,pA'\ wD
€€€€€€€€€€€€€€€€ - DROP€€€€ ROLLBACK SEGMENT
"e*I$h7R{!iv.E-\7h I051TestingÈí¼þ²âÊÔÍø iQ5m%`;mq-kx
SAVEPOINT
,kZ.l%U4U
K(yO0Schema - CREATE SCHEMA51TestingÈí¼þ²âÊÔÍø-SE6oq/j5X#Jk$s+\ W
SELECT51TestingÈí¼þ²âÊÔÍø!r1i$ro-L9O V4u
Sequence - CREATE SEQUENCE
7EW6l([9K
uJq^J?0€€€€€€€€€€€€€€€€ - ALTER€€ SEQUENCE
Qq9S-G%xdO
{_fX0`0€€€€€€€€€€€€€€€€ - DROP€€€€ SEQUENCE
D)T/mt4OS2_X%k0Session - ALTER SESSION
!~*n-Np.kUr b,c4?X0SHUTDOWN
+X%eI ^!`)qKxO`0SNAPSHOT51TestingÈí¼þ²âÊÔÍø lD8r:QjP x
SPfile - CREATE SPFILE
gP^C(tzu5m0STARTUP51TestingÈí¼þ²âÊÔÍø {)w&R!u Pi
Statistics - ASSOCIATE STATISTICS51TestingÈí¼þ²âÊÔÍø:w8z,wO9N6li!C+x5P
€€€€€€€€€€€€€€€€€€€€ - DISASSOCIATE STATISTICS51TestingÈí¼þ²âÊÔÍø[D4lRr
Synonym - CREATE SYNONYM51TestingÈí¼þ²âÊÔÍø{9MO&F mNeDb
€€€€€€€€€€€€€€ - DROP€€€€ SYNONYM
)]Ip4N+BG'h"SQ0System - ALTER SYSTEM51TestingÈí¼þ²âÊÔÍø4mp$W)Q,}UM(C[6W"^"_

e5za kP0Table - CREATE TABLE
)u]
a-N)i2~2P0€€€€€€€€€€ - ALTER€€ TABLE
x5G/Hx _|7AJ:g]0€€€€€€€€€€ - DROP€€€€ TABLE51TestingÈí¼þ²âÊÔÍøv$bW&Dv`(lr
Tablespace - CREATE TABLESPACE
(_Up!`0Zv8Sn0€€€€€€€€€€€€€€€€€€€€ - ALTER€€ TABLESPACE51TestingÈí¼þ²âÊÔÍø,O[T,NH9y]N(y
€€€€€€€€€€€€€€€€€€€€ - DROP€€€€ TABLESPACE51TestingÈí¼þ²âÊÔÍø8Ot6p#N_1X-{6y
€€€€€€€€€€€€€€€€€€€€ - CREATE TEMPORARY TABLESPACE51TestingÈí¼þ²âÊÔÍø)B(v:Yi"jRy[F+r
Transaction - SET TRANSACTION
%aQ7?)d+bD
x0Trigger - CREATE TRIGGER51TestingÈí¼þ²âÊÔÍø&tT:XuIG.]p
€€€€€€€€€€€€€€ - ALTER€€ TRIGGER51TestingÈí¼þ²âÊÔÍøi&^#F6Z,IU({l1S8{
€€€€€€€€€€€€€€ - DROP€€€€ TRIGGER51TestingÈí¼þ²âÊÔÍø'a RU.m'E4imD
]
TRUNCATE51TestingÈí¼þ²âÊÔÍøMC1~E0U.D!J%L A
Type - CREATE TYPE
wkx_,a&z0€€€€€€€€ - ALTER TYPE
L5].y#X/DB0€€€€€€€€ - DROP TYPE51TestingÈí¼þ²âÊÔÍøLv;Wm5?N~V
€€€€€€€€ - CREATE TYPE BODY
RoUOUNsg+k&W0€€€€€€€€ - DROP TYPE BODY51TestingÈí¼þ²âÊÔÍø$Z(nX4?)y%y/Ru[L^ w'V

+]*n6_
~;q0UPDATE51TestingÈí¼þ²âÊÔÍøbD'w)YR%\
UNION
+G-L'ar:G!N0User - CREATE USER
9@rq1j k$[(R0€€€€€€€€ - ALTER€€ USER
+@-d3J9u'pQs0€€€€€€€€ - DROP€€€€ USER51TestingÈí¼þ²âÊÔÍøS#Z+cL:s [

oOlS tvh*f0View - CREATE VIEW51TestingÈí¼þ²âÊÔÍø6oM P:G2l k!F!D+@
€€€€€€€€ - ALTER€€ VIEW
LR\L]hU0€€€€€€€€ - DROP€€€€ VIEW
(_.v(n G~C0 51TestingÈí¼þ²âÊÔÍøc$u(w$f)MDl

SYNTAX:51TestingÈí¼þ²âÊÔÍø*N5`8MsU5r$k

%d ~Y(w6eQNm(E0Words in CAPS are Oracle commands, words in lower-case are the options you can modify.51TestingÈí¼þ²âÊÔÍøR]z8kZ1r)c
Sections enclosed in [] are optional, underlined options are the default
M*gTypD kQ0Sections enclosed in {} are alternatives. The pipe symbol | indicates OR (more)

)x-x]C]|:K0