保留字和关键字是在 PL/SQL 中具有特殊含义的标识符。它们不区分大小写。有关它们的更多信息,请参阅“保留字词和关键字”。
首字母 | 保留字 |
---|---|
A | ALL |
B | BEGIN, BY |
C | CASE |
D | DECLARE |
E | ELSE, END, EXECUTE |
F | FOR, FORALL, FOREACH, FROM, FUNCTION |
G | GOTO |
H | HAVING |
I | IF, IN, INTO |
L | LOOP |
N | NOT, NULL |
O | OR |
P | PROCEDURE |
S | STRICT |
T | THEN, TO |
U | USING |
W | WHEN, WHILE, WRAPPED |
首字母 | 关键字 |
---|---|
A | ABSOLUTE, ALIAS, AND, ARRAY, AS, ASSERT |
B | BACKWARD, BETWEEN, BULK |
C | CALL, CHAIN, CLOSE, COLLATE, COLLECT, COLUMN, COLUMN_NAME, COMMIT, CONSTANT, CONSTRAINT, CONSTRAINT_NAME, CONSTRUCTOR, CONTINUE, COUNT, CURRENT, CURSOR |
D | DATATYPE, DEBUG, DEFAULT, DELETE, DETAIL, DETERMINISTIC, DIAGNOSTICS, DO, DUMP |
E | ELSEIF, ELSIF, ERRCODE, ERROR, EXCEPTION, EXCEPTION_INIT, EXCEPTIONS, EXISTS, EXIT, EXTEND |
F | FETCH, FIRST, FORWARD |
G | GET |
H | HINT |
I | IMMEDIATE, IMMUTABLE, IMPORT, INDEX, INDICES, INFO, INOUT, INSERT, IS |
L | LAST, LIMIT, LOG |
M | MEMBER, MERGE, MESSAGE, MESSAGE_TEXT, MOVE |
N | NEXT, NO, NOCOPY, NOTICE |
O | OF, OPEN, OPTION, OUT |
P | PERFORM, PG_CONTEXT, PG_DATATYPE_NAME, PG_EXCEPTION_CONTEXT, PG_EXCEPTION_DETAIL, PG_EXCEPTION_HINT, PIPE, PIPELINED, PRAGMA, PRINT_STRICT_PARAMS, PRIOR |
Q | QUERY |
R | RAISE, RANGE, RECORD, REF, RELATIVE, RELIES_ON, RESET, RESULT, RESULT_CACHE, RETURN, RETURNED_SQLSTATE, RETURNING, RETURNS, REVERSE, ROLLBACK, ROW, ROW_COUNT, ROWTYPE |
S | SAVE, SCHEMA, SCHEMA_NAME, SCROLL, SELF, SET, SETOF, SLICE, SQLSTATE, STABLE, STACKED, STATIC, SUBTYPE |
T | TABLE, TABLE_NAME, TRIM, TYPE |
U | UPDATE, USE_COLUMN, USE_VARIABLE |
V | VALUES, VARIABLE_CONFLICT, VARRAY, VARYING, VOLATILE |
W | WARNING |