オラクルで予約されている単語
語尾の ＊ 付きはANSIでも予約語
- A (SQL)
- ACCESS,
ADD *,
ALL *,
ALTER *,
AND *,
ANY *,
AS *,
ASC *,
AUDIT
- A (PL/SQL)
- ARRAY,
AT,
AUTHID,
AVG
- A (マニュアルにない怪しいもの)
- A,
ABORT,
ACCESSED,
ACCOUNT,
ACTIVATE,
ADMIN,
ADMINISTER,
ADMINISTRATOR,
ADVISE,
ADVISOR,
AFTER,
ALGORITHM,
ALIAS,
ALLOCATE,
ALLOW,
ANALYZE
- B (SQL)
- BETWEEN *,
BY *
- B (PL/SQL)
- BEGIN,
BINARY_INTEGER,
BODY,
BOOLEAN,
BULK
- C (SQL)
- CHAR *,
CHECK *,
CLUSTER,
COLUMN,
COMMENT,
COMPRESS,
CONNECT *,
CREATE *,
CURRENT *
- C (PL/SQL)
- CASE,
CHAR_BASE,
CLOSE,
COALESCE,
COLLECT,
COMMIT,
CONSTANT,
CURRVAL,
CURSOR
- D (SQL)
- DATE *,
DECIMAL *,
DEFAULT *,
DELETE *,
DESC *,
DISTINCT *,
DROP *
- D (PL/SQL)
- DAY,
DECLARE,
DO
- E (SQL)
- ELSE *,
EXCLUSIVE,
EXISTS
- E (PL/SQL)
- ELSIF,
END,
EXCEPTION,
EXECUTE,
EXIT,
EXTENDS,
EXTRACT
- F (SQL)
- FILE,
FLOAT *,
FOR *,
FROM *
- F (PL/SQL)
- FALSE,
FETCH,
FORALL,
FUNCTION
- G (SQL)
- GRANT *,
GROUP *
- G (PL/SQL)
- GOTO
- H (SQL)
- HAVING *
- H (PL/SQL)
- HEAP,
HOUR
- I (SQL)
- IDENTIFIED,
IMMEDIATE *,
IN *,
INCREMENT,
INDEX,
INITIAL,
INSERT *,
INTEGER *,
INTERSECT *,
INTO *,
IS *
- I (PL/SQL)
- IF,
IMMEDIATE*,
INDICATOR,
INTERFACE,
INTERVAL,
ISOLATION
- J (PL/SQL)
- JAVA
- L (SQL)
- LEVEL *,
LIKE *,
LOCK,
LONG
- L (PL/SQL)
- LIMITED,
LOOP
- M (SQL)
- MAXEXTENTS,
MINUS,
MLSLABEL,
MODE,
MODIFY
- M (PL/SQL)
- MAX,
MIN,
MINUTE,
MOD,
MONTH
- N (SQL)
- NOAUDIT,
NOCOMPRESS,
NOT *,
NOWAIT,
NULL *,
NUMBER
- N (PL/SQL)
- NATURAL,
NATURALN,
NEW,
NEXTVAL,
NOCOPY,
NULLIF,
NUMBER_BASE
- O (SQL)
- OF *,
OFFLINE,
ON *,
ONLINE,
OPTION *,
OR *,
ORDER *
- O (PL/SQL)
- OCIROWID,
OPAQUE,
OPEN,
OPERATOR,
ORGANIZATION,
OTHERS,
OUT
- P (SQL)
- PCTFREE,
PRIOR *,
PRIVILEGES *,
PUBLIC *
- P (PL/SQL)
- PACKAGE,
PARTITION,
PLS_INTEGER,
POSITIVE,
POSITIVEN,
PRAGMA,
PRIVATE,
PROCEDURE
- R (SQL)
- RAW,
RENAME,
RESOURCE,
REVOKE *,
ROW,
ROWID,
ROWNUM,
ROWS *
- R (PL/SQL)
- RAISE,
RANGE,
REAL,
RECORD,
REF,
RELEASE,
RETURN,
REVERSE,
ROLLBACK,
ROWTYPE
- S (SQL)
- SELECT *,
SESSION *,
SET *,
SHARE,
SIZE *,
SMALLINT *,
START,
SUCCESSFUL,
SYNONYM,
SYSDATE
- S (PL/SQL)
- SAVEPOINT,
SECOND,
SEPARATE,
SPACE,
SQL,
SQLCODE,
SQLERRM,
START*,
STDDEV,
SUBTYPE,
SUM
- T (SQL)
- TABLE *,
THEN *,
TO *,
TRIGGER
- T (PL/SQL)
- TIME,
TIMESTAMP,
TIMEZONE_REGION,
TIMEZONE_ABBR,
TIMEZONE_MINUTE,
TIMEZONE_HOUR,
TRUE,
TYPE
- U (SQL)
- UID,
UNION *,
UNIQUE *,
UPDATE *,
USER *
- U (PL/SQL)
- USE
- V (SQL)
- VALIDATE,
VALUES *,
VARCHAR *,
VARCHAR2,
VIEW *
- V (PL/SQL)
- VARIANCE
- W (SQL)
- WHENEVER *,
WHERE,
WITH *
- W (PL/SQL)
- WHEN,
WHILE,
WORK,
WRITE,
- Y (PL/SQL)
- YEAR
- Z (PL/SQL)
- ZONE
|
