Appendix





Appendix A

Reserved Words


Reserved Words
ACCESS ADD ALL ALTER
AND ANY AS ASC
AUDIT BETWEEN BY CHAR
CHECK CLUSTER COLUMN COMMENT
COMPRESS CONNECT CREATE CURRENT
DATE DECIMAL DEFAULT DELETE
DESC DISTINCT DROP ELSE
EXCLUSIVE EXISTS FILE FLOAT
FOR FROM GRANT GROUP
HAVING IDENTIFIED IMMEDIATE IN
INCREMENT INDEX INITIAL INSERT
INTEGER INTERSECT INTO IS
LEVEL LIKE LOCK LONG
MAXEXTENTS MINUS MODE MODIFY
NOAUDIT NOCOMPRESS NOT NOWAIT
NULL NUMBER OF OFFLINE
ON ONLINE OPTION OR
ORDER PCTFREE PRIOR PRIVILEGES
PUBLIC RAW RENAME RESOURCE
REVOKE ROW ROWID ROWLABEL
ROWNUM ROWS SELECT
SET SHARE SIZE SMALLINT
START SUCCESSFUL SYNONYM SYSDATE
TABLE THEN TO TRIGGER
UID UNION UNIQUE UPDATE
USER VALIDATE VALUES VARCHAR
VARCHAR2 VIEW WHENEVER WHERE
WITH






Appendix B

Keywords


Keywords
ADMIN AFTER ALLOCATE ANALYZE
ARCHIVE ARCHIVELOG AUTHORIZATION AVG
BACKUP BEGIN BECOME BEFORE
BLOCK BODY CACHE CANCEL
CASCADE CHANGE CHARACTER CHECKPOINT
CLOSE COBOL COMMIT COMPILE
CONSTRAINT CONSTRAINTS CONTENTS CONTINUE
CONTROLFILE COUNT CURSOR CYCLE
DATABASE DATAFILE DBA DEC
DECLARE DISABLE DISMOUNT DOUBLE
DUMP EACH ENABLE END
ESCAPE EVENTS EXCEPT EXCEPTIONS
EXEC EXPLAIN EXECUTE EXTENT
EXTERNALLY FETCH FLUSH FREELIST
FREELISTS FORCE FOREIGN FORTRAN
FOUND FUNCTION GO GOTO
GROUPS INCLUDING INDICATOR INTTRANS
INSTANCE INT KEY LANGUAGE
LAYER LINK LISTS LOGFILE
MANAGER MANUAL MAX MAXDATAFILES
MAXINSTANCES MAXLOGFILES MAXLOGHISTORY MAXLOGMEMBERS
MAXTRANS MAXVALUE MIN MINEXTENTS
MINVALUE MODULE MOUNT NEXT
NEW NOARCHIVELOG NOCACHE NOCYCLE
NOMAXVALUE NOMINVALUE NONE NOORDER
NORESETLOGS NORMAL NOSORT NUMERIC
OFF OLD ONLY OPTIMAL
OPEN OWN PACKAGE PARALLEL
PASCAL PCTINCREASE PCTUSED PLAN
PLI PRECISION PRIMARY PRIVATE
PROCEDURE PROFILE QUOTA READ
REAL RECOVER REFERENCES REFERENCING
RESETLOGS RESTRICTED REUSE ROLE
ROLES ROLLBACK SAVEPOINT SCHEMA
SCN SECTION SEGMENT SEQUENCE
SHARED SNAPSHOT SOME SORT
SQL SQLCODE SQLERROR STATEMENT_ID
STATISTICS STOP STORAGE SUM
SWITCH SYSTEM TABLES TABLESPACE
TEMPORARY THREAD TIME TRACING
TRANSACTION TRIGGERS TRUNCATE UNDER
UNLIMITED UNTIL USE USING
WHEN WRITE WORK






Appendix C

Control File Syntax