Appendix B. COMMAND
COMMAND의 종류에 대하여 설명합니다.
COMMAND_TYPES TABLE을 조회하면 같은 내용을 볼 수 있습니다.
0
NONE
1
SELECT
2
INSERT
3
UPDATE
4
DELETE
5
MERGE
6
CALL
7
CREATE DATABASE
8
ALTER DATABASE
9
CREATE TABLE
10
ALTER TABLE
11
DROP TABLE
12
CREATE INDEX
13
ALTER INDEX
14
DROP INDEX
15
CREATE VIEW
16
ALTER VIEW
17
DROP VIEW
18
CREATE MVIEW
19
ALTER MVIEW
20
DROP MVIEW
21
CREATE MLOG
22
ALTER MLOG
23
DROP MLOG
24
CREATE USER
25
ALTER USER
26
DROP USER
27
ALTER SYSTEM
28
ALTER SESSION
29
SET ROLE
30
EXPLAIN
31
CREATE TABLESPACE
32
ALTER TABLESPACE
33
DROP TABLESPACE
34
CREATE SEQUENCE
35
ALTER SEQUENCE
36
DROP SEQUENCE
37
CREATE SYNONYM
38
ALTER SYNONYM
39
DROP SYNONYM
40
CREATE ROLE
41
ALTER ROLE
42
DROP ROLE
43
CREATE PROCEDURE
44
ALTER PROCEDURE
45
DROP PROCEDURE
46
CREATE FUNCTION
47
ALTER FUNCTION
48
DROP FUNCTION
49
CREATE PACKAGE
50
ALTER PACKAGE
51
DROP PACKAGE
52
CREATE PACKAGE BODY
53
DROP PACKAGE BODY
54
CREATE TRIGGER
55
ALTER TRIGGER
56
DROP TRIGGER
57
CREATE LIBRARY
58
DROP LIBRARY
59
CREATE JAVA
60
DROP JAVA
61
CREATE DATABASE LINK
62
CREATE PUBLIC DATABASE LINK
63
CREATE ANY DATABASE LINK
64
DROP DATABASE LINK
65
DROP PUBLIC DATABASE LINK
66
DROP ANY DATABASE LINK
67
CREATE OUTLINE
68
DROP OUTLINE
69
CREATE DIRECTORY
70
DROP DIRECTORY
71
ALTER TYPE
72
CREATE TYPE
73
DROP TYPE
74
CREATE TYPE BODY
75
DROP TYPE BODY
76
GRANT OBJPRIV
77
REVOKE OBJPRIV
78
GRANT SYSPRIV
79
REVOKE SYSPRIV
80
AUDIT
81
NOAUDIT
82
RENAME
83
COMMENT
84
TRUNCATE
85
PURGE
86
FLASHBACK TABLE
87
CREATE CONTROL FILE
88
ALTER ROLLBACK SEG
89
CREATE PROFILE
90
ALTER PROFILE
91
DROP PROFILE
92
COMMIT
93
ROLLBACK
94
SAVEPOINT
95
SET TRANSACTION
96
LOCK
97
CREATE DISKSPACE
98
ALTER DISKSPACE
99
DROP DISKSPACE
100
MODIFY DISKSPACE
101
CREATE BTIP
102
CREATE TIP
103
CREATE CONTEXT
104
DROP CONTEXT
105
CREATE SSVR
106
CREATE SDISK
107
DROP SDISK
108
CREATE GDISK
109
DROP GDISK
110
CREATE SFC
111
DROP SFC
112
ALTER SFC
113
ALTER IORMPLAN
114
CREATE CONTROL FILE SSVR
115
ALTER RMGR
116
DOWNGRADE DATABASE
117
CREATE OPERATOR
118
ALTER OPERATOR
119
DROP OPERATOR
120
CREATE INDEXTYPE
121
ALTER INDEXTYPE
122
DROP INDEXTYPE
123
ASSOCIATE STATISTICS
124
DISASSOCIATE STATISTICS
Last updated