Identified {by password | externally}

[DEFAULT TABLESPACE tablespace]

[TEMPORARY TABLESPACE tablespace]

[QUOTA {integer [K|M] | UNLIMITED} ON tablespace] ...

[PROFILE profile]

CREATE [OR REPLACE] [FORCE | !!under!!NOFORCE] VIEW [schema.]view

[(alias [,alias]...)]

AS subquery

[WITH CHECK OPTION [CONSTRAINT constraint]]

dblink database[.domain]...[@connection_qualifier]

DELETE [FROM] [schema.]{table | view}[@dblink] [alias] [WHERE condition]

DROP CLUSTER [schema.]cluster

[INCLUDING TABLES [CASCADE CONSTRAINTS] ]

DROP [PUBLIC] DATABASE LINK dblink

DROP FUNCTION [schema.]function

DROP INDEX [schema.]index

DROP PACKAGE [BODY] [schema.]package

DROP PROCEDURE [schema.]procedure

DROP PROFILE profile [CASCADE]

DROP ROLE role

DROP ROLLBACK SEGMENT rollback_segment

DROP SEQUENCE [schema.]sequence

DROP SNAPSHOT [schema.]snapshot

DROP SNAPSHOT LOG ON [schema.]table

DROP [PUBLIC] SYNONYM [schema.]synonym

DROP TABLE [schema.]table [CASCADE CONSTRAINTS]

DROP TABLESPACE tablespace [INCLUDING CONTENTS [CASCADE CONSTRAINTS]]

DROP TRIGGER [schema.]trigger

DROP USER user [CASCADE]

DROP VIEW [schema.]view

EXPLAIN PLAN [SET STATEMENT ID = `text`] [INTO [schema.]table[@dblink]]

FOR statement

GRANT {system_priv | role} [, {system_priv | role}] ...

TO {user | role | PUBLIC} [, {user | role | PUBLIC}] ...

[WITH ADMIN OPTION]

- 23 -

GRANT {object_priv | ALL [PRIVILEGES]} [ (column [, column]...) ]

[, {object_priv | ALL [PRIVILEGES]} [ (column [, column] ...) ] ] ...

ON [schema.]object

TO {user | role | PUBLIC} [, {user | role | PUBLIC}] ...

[WITH GRANT OPTION]

INSERT INTO [schema.]{table | view}[@dblink] [ (column [, column] ...) ]

{VALUES (expr [, expr] ...) | subquery}

LOCK TABLE [schema.]{table | view}[@dblink]

[, [schema.]{table | view}[@dblink] ]...

IN lockmode MODE

[NOWAIT]

NOAUDIT {statement_opt | system_priv}

[, {statement_opt | system_priv} ] ...

[BY user [, user] ...]

[WHENEVER [NOT] SUCCESSFUL]

NOAUDIT object_opt [, object_opt] ...

ON [schema.]object

[WHENEVER [NOT] SUCCESSFUL]

RENAME old TO new

REVOKE {system_priv | role} [, {system_priv | role}] ...

FROM {user | role | PUBLIC}

[, {user | role | PUBLIC}] ...

REVOKE {object_priv | ALL [PRIVILEGES]}

[, {object_priv | ALL [PRIVILEGES]} ] ...

ON [schema.]object

FROM {user | role | PUBLIC} [, {user | role | PUBLIC}] ...

[CASCADE CONSTRAINTS]

ROLLBACK [WORK]

[ TO [SAVEPOINT] savepoint | FORCE `text` ]

SAVEPOINT savepoint

SELECT [DISTINCT | !!under!!ALL] { *

| { [schema.]{table | view | snapshot}.*

| expr [ [AS] c_alias ] }

[, { [schema.]{table | view | snapshot}.*

| expr [ [AS] c_alias ] } ] ... }

FROM { (subquery)

| [schema.]{table | view | snapshot}[@dblink] } [t_alias]

[, { (subquery)

| [schema.]{table | view | snapshot}[@dblink] } [t_alias] ] ...

[WHERE condition ]

[ [START WITH condition] CONNECT BY condition]

[GROUP BY expr [, expr] ...] [HAVING condition]

[{UNION | UNION ALL | INTERSECT | MINUS} SELECT command ]

[ORDER BY {expr | c_alias | position} [!!under!!ASC | DESC]

[, {expr | c_alias | position}

[!!under!!ASC | DESC]] ...]

[FOR UPDATE [OF [[schema.]{table | view}.]column

[, [[schema.]{table | view}.]column] ...]

[NOWAIT] ]

- 24 -

SET ROLE { role [IDENTIFIED BY password]

[, role [IDENTIFIED BY password] ] ...

| ALL [EXCEPT role [, role] ...]

| NONE }

SET TRANSACTION

{ READ ONLY

| READ WRITE

| USE ROLLBACK SEGMENT rollback_segment }

TRUNCATE {TABLE [schema.]table | CLUSTER [schema.]cluster}

[ {!!under!!DROP | REUSE} STORAGE]

UPDATE [schema.]{table | view}[@dblink] [alias]

SET { (column [, column] ...) = (subquery)

| column = { expr | (subquery) } }

[, { (column [, column] ...) = (subquery)

| column = { expr | (subquery) } } ] ...

[WHERE condition]