[(INDEX index [PREFETCH size] [LRU I HRU])] [HOLDLOCK I

NOHOLDLOCK] [SHARED]]...

[WHERE conditions]

[GROUP BY [ALL] {column expr} [, column expr]...

[HAVING conditions]

[ORDER BY {column position expr I label) [ASC DESC] [({column I position expr label) [ASC I DESC]]...] [COMPUTE row aggregate (column) [, row aggregate (column)]...] [BY column [, column l-.-ll

[FOR {READ ONLY

I UPDATE [OF column list]}]

[AT ISOLATION {READ~

UNCOMMITTED I READ

COMMITTED I SERIALIZ-

ABLE}]

[FOR BROWSE]

I [NATURAL I KEY] LEFT OUTER JOIN

I [NATURAL I KEY] RIGHT OUTER JOIN)

table [alias] (ON conditions] [WHERE conditions]

(GROUP BY {column label function) [, column label function]... ] [HAVING conditions]

[ORDER BY {column position label) [ASC DESC] [({column I position label) [ASC I DESC]]...]

[, table [alias]

[({INDEX = {name id) NOLOCK I HOLDLOCK UPDLOCK TABLOCK PAGLOCK TABLOCKX FASTFIRSTROW)...)]]...

(WHERE conditions)

[GROUP BY [ALL] {column expr) [, column expr]... [HAVING conditions]

[ORDER BY {column position 1

expr ! label) [ASC DESC] , {column I position expr label) (ASC I DESC]]...] [COMPUTE row aggregate (column) [, row aggregate (column)]...]

[BY column [, column]...] ]

[WHERE conditions]

[GROUP BY {column position) [, column I position]...] [HAVING conditions]

[ORDER BY {column position label) [ASC I DESC] (.{column I position label) [ASC I DESC1J...J

[INTO TEMP temptable (WITH NOLOG]]

[FOR BROWSE]

[WHERE conditions] (CONNECT BY condition [START WITH condition ]] [GROUP BY {column expr) [, {column I expr)...]

[HAVING conditions]

{ UNION [ALL] I INTERSECT

MINUS ) SELECT ...] [ORDER BY {expr I position label ) (ASC DESC] (,{expr I position label } [ASC I DESC]]...]

[FOR UPDATE [OF {table. view.) column [, {table. view.) column]...J [NOWAIT]]

INSERT [INTO] {table ((column list)] {VALUES (values list) select statement)

view)

INSERT INTO table [(column list) 1 (VALUES I (expr I DEFAULT] [,expr I DEFAULT]...) I select statement)

INSERT ]INTO] {table view)

[(column list) ]

{DEFAULT VALUES

I VALUES {DEFAULT expr)

[, DEFAULT I expr]...

I select statement)

INSERT INTO {table view synonym) [(colmnn list)] {VALUES (values list

select statement

EXECUTE PROCEDURE procedure [(parameter [, param-eter]...))

INSERT INTO table [(column list) ] {VALUES (values list) I select statement)

DELETE {[FROM {table view) I FROM {view table [( INDEX index [PREFETCH size] [LRU I MRU])]) [, {view I table ((INDEX index [PREFETCH size) [LRU I MRU])])]...) [WHERE conditions]

DELETE [FROM] table [FROM table ], table]...]

[WHERE conditions]

DELETE [FROM] {table view)

[WHERE conditions]

DELETE [FROM] {table view synonym)

[WHERE conditions]

DELETE [FROM] table [alias]

[WHERE conditions]

АДМИНИСТРИРОВАНИЕ ДАННЫХ

Для администрирования данных используются команды GRANT и REVOKE.

ON {table [ (со1шш

[, column]...)]

I view [{column [, column].

I procedure)

TO { PmiC I user [, user] role)

I WITH GRJftT OPITION]

ON table

TO userid [, userid]... I WITH GRANT OPITION]

ON {table [ (column (, column]...Ц

view [(column [, coumn]...)

procedure

extended procedure] TO { PUBLIC I user [, user]...)

ON {table view synonym ) TO {PUBLIC I user (, user]...) I WITH GRANT OPITION] (AS GRANTOR]

ON {table I view procedure) TO (PUBLIC I user [, user]...] role [, role]...) I WITH GRANT OPITION]

Полномочия на базу данных GRANT{ALL

I CREATE/DUMP commands)

TO {PUBLIC I user [,user]...)

Полномочия на базу данных GRANT

{ALL [PRIVILEGES]

I CREATE oommands)

TO {PUBLIC I user [,user]..

I role)

Полномочия на базу данных GRANT {DBA I RESOURCE GROUP I MEMBERSHIP IN GROUP userid } [, DBA I RESOURCE GROUP] MEMBERSHIP IN GROUP userid]... TO userid

Полномочия на процедуру

GRANT EXECUTE

ON procedure

TO userid [, userid]...

Полномочия нового пользователя

GRANT CONNECT TO userid

[, userid]...

IDENTIFIED BY password (,

password]...

Полномочия на базу данных GRANT {CONNECT RESOURCE DBA) (, CONNECT ] RESOURCE 1 DBA]... TO {PUBLIC ] user [, user]...)

Полномочия на процедуру GRANT EXECUTE ON procedure

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

Полномочия на базу данных GRANT {system privilege [, system privilege]... ] role [, role] ...}

TO [PUBLIC ] user [, user]...

role I, role]...} ], PUBLIC user [,

user]... I role [, role]...]...

[WITH ADMIN OPTION]

Полномочия на объекты REVOKE

[GRANT OPTION FOR] {ALL [PRIVILEGES] ] {SELECT ] INSERT ] DELETE I UPDATE ] REFERENCES ] EXECUTE) (, SELECT ] INSERT DELETE UPDATE J REFERENCES ] EXECUTE]...}

ON {table [(column [, column]...)]

view [(column [, column (...)]

procedure) FROM {PUBLIC ] user [, user]...] role [, role]...} [CASCADE)

Полномочия на объекты REVOKE {SELECT ] INSERT ] DELETE ] UPDATE [(column [, column]...)] ] REFERENCES ] ALTER)

[, SELECT ] INSERT ] DELETE ] UPDATE [ (column [, column ]...)] ] REFERENCES ALTER) ON table

FROM userid [, userid]...

Полномочия на обгехты REVOKE

{ALL] (SELECT ] INSERT DELETE ] UPDATE ] REFERENCES ] EXECUTE) [, SELECT ] INSERT ] DELETE ] UPDATE I REFERENCES ] EXECUTE]...} ON {table [(column [, column]...)] j view 1(column [, column]...)] procedure

extended procedure) FROM {PUBLIC ] user [, user]...)

Полномочия яа объехты REVOKE {SELECT ] INSERT ] DELETE ] UPDATE ] REFER-ENCES ALTER I INDEX)

[, SELECT ] INSERT ] DELETE ]

UPDATE 1 REFERENCES ]

ALTER ] INDEX)

ON {table ] view ] synonym)

FROM {PUBLIC ] user [, user]...)

Полномочия на объекты REVOKE {SELECT [(column [, column]...)] I INSERT I DELETE ] UPDATE [(column [, column]...)] I REFERENCES [(column [, column]...)] ALTER

] INDEX)], SELECT [(column [, column]...)] ] INSERT ] DELETE ] UPDATE [(column [, column]...)] J REFERENCES [(column [, column]...)] ] ALTER ]INDEX]...) ON {table ] view ] procedure) FROM {PUBLIC I user [, user]...] role 1, role]...) (CASCADE CONSTRAINTS]