oracle select v$sql,V$SQLCOMMAND SQL opcodes and names

V$SQLCOMMAND SQL opcodes and names

SQL> select command_type,command_name from V$SQLCOMMAND;

COMMAND_TYPE COMMAND_NAME

------------ ----------------------------------------------------------

0

1 CREATE TABLE

2 INSERT

3 SELECT

4 CREATE CLUSTER

5 ALTER CLUSTER

6 UPDATE

7 DELETE

8 DROP CLUSTER

9 CREATE INDEX

10 DROP INDEX

11 ALTER INDEX

12 DROP TABLE

13 CREATE SEQUENCE

14 ALTER SEQUENCE

15 ALTER TABLE

16 DROP SEQUENCE

17 GRANT OBJECT

18 REVOKE OBJECT

19 CREATE SYNONYM

20 DROP SYNONYM

21 CREATE VIEW

22 DROP VIEW

23 VALIDATE INDEX

24 CREATE PROCEDURE

25 ALTER PROCEDURE

26 LOCK TABLE

27 NO-OP

28 RENAME

29 COMMENT

30 AUDIT OBJECT

31 NOAUDIT OBJECT

32 CREATE DATABASE LINK

33 DROP DATABASE LINK

34 CREATE DATABASE

35 ALTER DATABASE

36 CREATE ROLLBACK SEG

37 ALTER ROLLBACK SEG

38 DROP ROLLBACK SEG

39 CREATE TABLESPACE

40 ALTER TABLESPACE

41 DROP TABLESPACE

42 ALTER SESSION

43 ALTER USER

44 COMMIT

45 ROLLBACK

46 SAVEPOINT

47 PL/SQL EXECUTE

48 SET TRANSACTION

49 ALTER SYSTEM

50 EXPLAIN

51 CREATE USER

52 CREATE ROLE

53 DROP USER

54 DROP ROLE

55 SET ROLE

56 CREATE SCHEMA

57 CREATE CONTROL FILE

58 ALTER TRACING

59 CREATE TRIGGER

60 ALTER TRIGGER

61 DROP TRIGGER

62 ANALYZE TABLE

63 ANALYZE INDEX

64 ANALYZE CLUSTER

65 CREATE PROFILE

66 DROP PROFILE

67 ALTER PROFILE

68 DROP PROCEDURE

70 ALTER RESOURCE COST

71 CREATE MATERIALIZED VIEW LOG

72 ALTER MATERIALIZED VIEW LOG

73 DROP MATERIALIZED VIEW LOG

74 CREATE MATERIALIZED VIEW

75 ALTER MATERIALIZED VIEW

76 DROP MATERIALIZED VIEW

77 CREATE TYPE

78 DROP TYPE

79 ALTER ROLE

80 ALTER TYPE

81 CREATE TYPE BODY

82 ALTER TYPE BODY

83 DROP TYPE BODY

84 DROP LIBRARY

85 TRUNCATE TABLE

86 TRUNCATE CLUSTER

87 CREATE BITMAPFILE

88 ALTER VIEW

89 DROP BITMAPFILE

90 SET CONSTRAINTS

91 CREATE FUNCTION

92 ALTER FUNCTION

93 DROP FUNCTION

94 CREATE PACKAGE

95 ALTER PACKAGE

96 DROP PACKAGE

97 CREATE PACKAGE BODY

98 ALTER PACKAGE BODY

99 DROP PACKAGE BODY

157 CREATE DIRECTORY

158 DROP DIRECTORY

159 CREATE LIBRARY

160 CREATE JAVA

161 ALTER JAVA

162 DROP JAVA

163 CREATE OPERATOR

164 CREATE INDEXTYPE

165 DROP INDEXTYPE

166 ALTER INDEXTYPE

167 DROP OPERATOR

168 ASSOCIATE STATISTICS

169 DISASSOCIATE STATISTICS

170 CALL METHOD

171 CREATE SUMMARY

172 ALTER SUMMARY

173 DROP SUMMARY

174 CREATE DIMENSION

175 ALTER DIMENSION

176 DROP DIMENSION

177 CREATE CONTEXT

178 DROP CONTEXT

179 ALTER OUTLINE

180 CREATE OUTLINE

181 DROP OUTLINE

182 UPDATE INDEXES

183 ALTER OPERATOR

184 Do not use 184

185 Do not use 185

186 Do not use 186

187 CREATE SPFILE

188 CREATE PFILE

189 UPSERT

190 CHANGE PASSWORD

191 UPDATE JOIN INDEX

192 ALTER SYNONYM

193 ALTER DISK GROUP

194 CREATE DISK GROUP

195 DROP DISK GROUP

196 ALTER LIBRARY

197 PURGE USER RECYCLEBIN

198 PURGE DBA RECYCLEBIN

199 PURGE TABLESPACE

200 PURGE TABLE

201 PURGE INDEX

202 UNDROP OBJECT

203 DROP DATABASE

204 FLASHBACK DATABASE

205 FLASHBACK TABLE

206 CREATE RESTORE POINT

207 DROP RESTORE POINT

209 DECLARE REWRITE EQUIVALENCE

210 ALTER REWRITE EQUIVALENCE

211 DROP REWRITE EQUIVALENCE

212 CREATE EDITION

213 ALTER EDITION

214 DROP EDITION

215 DROP ASSEMBLY

216 CREATE ASSEMBLY

217 ALTER ASSEMBLY

218 CREATE FLASHBACK ARCHIVE

219 ALTER FLASHBACK ARCHIVE

220 DROP FLASHBACK ARCHIVE

222 CREATE SCHEMA SYNONYM

224 DROP SCHEMA SYNONYM

225 ALTER DATABASE LINK

226 CREATE PLUGGABLE DATABASE

227 ALTER PLUGGABLE DATABASE

228 DROP PLUGGABLE DATABASE

229 CREATE AUDIT POLICY

230 ALTER AUDIT POLICY

231 DROP AUDIT POLICY

238 ADMINISTER KEY MANAGEMENT

239 CREATE MATERIALIZED ZONEMAP

240 ALTER MATERIALIZED ZONEMAP

241 DROP MATERIALIZED ZONEMAP

©著作权归作者所有：来自51CTO博客作者maclean_007的原创作品，如需转载，请注明出处，否则将追究法律责任