Классика баз данных - статьи

       

IF boolean THEN


trig-condition ::= action | READ OF table-name [ var-name ]

statement-list := cond-statement | statement-list; cond-statement

cond-statement ::= statement | IF boolean THEN statement

grant ::= GRANT [ auth ] table-name TO user-list [ WITH GRANT OPTION ]

auth ::= ALL RIGHTS ON | operation-list ON | ALL BUT operation-list ON

user-list ::= user-name | user-list, user-name | PUBLIC

operation-list ::= operation | operation-list, operation

operation ::= READ | INSERT | DELETE | UPDATE [ ( field-name-list ) ] | EXPAND | IMAGE | LINK | CONTROL | RUN

revoke ::= REVOKE [ operation-list ON ] table-name FROM user-list

begin-trans ::= BEGIN TRANSACTION

end-trans ::= END TRANSACTION

save ::= SAVE save-point-name

restore ::= RESTORE [ save-point-name ]

cursor-statement ::= let | open | fetch | close | describe | execute

let ::= LET cursor-name BE query | LET cursor-name BE execute

open ::= OPEN cursor-name

fetch ::= FETCH cursor-name [ INTO pointer ]

close ::= CLOSE cursor-name

describe ::= DESCRIBE cursor-name INTO pointer

execute ::= EXECUTE host-location


Содержание  Назад  Вперед