Tuesday, June 24, 2014

Sorted list of the Oracle Reserved Words, Keywords, and Namespaces

Thinking it would have been useful to many of you, I made a list (alphabetically sorted) of ALL (a served keyword, BTW! ) Oracle database keywords... so you can just copy and paste!

The source of this list is the official Oracle's documentation and I used Notepad++ with TextFX  to sort the list!
Enjoy!





ABORT
ACCEPT
ACCESS
ADD
ADMIN
AFTER
ALL
ALLOCATE
ALTER
ANALYZE
AND
ANY
ARCHIVE
ARCHIVELOG
ARRAY
ARRAYLEN
AS
ASC
ASSERT
ASSIGN
AT
AUDIT
AUTHORIZATION
AVG
BACKUP
BASE_TABLE
BECOME
BEFORE
BEGIN
BETWEEN
BINARY_INTEGER
BLOCK
BODY
BOOLEAN
BY
CACHE
CANCEL
CASCADE
CASE
CHANGE
CHAR
CHARACTER
CHAR_BASE
CHECK
CHECKPOINT
CLOSE
CLUSTER
CLUSTERS
COBOL
COLAUTH
COLUMN
COLUMNS
COMMENT
COMMIT
COMPILE
COMPRESS
CONNECT
CONSTANT
CONSTRAINT
CONSTRAINTS
CONTENTS
CONTINUE
CONTROLFILE
COUNT
CRASH
CREATE
CURRENT
CURRVAL
CURSOR
CYCLE
DATABASE
DATAFILE
DATA_BASE
DATE
DBA
DEBUGOFF
DEBUGON
DEC
DECIMAL
DECLARE
DEFAULT
DEFINITION
DELAY
DELETE
DELTA
DESC
DIGITS
DISABLE
DISMOUNT
DISPOSE
DISTINCT
DO
DOUBLE
DROP
DUMP
EACH
ELSE
ELSIF
ENABLE
END
ENTRY
ESCAPE
EVENTS
EXCEPT
EXCEPTION
EXCEPTIONS
EXCEPTION_INIT
EXCLUSIVE
EXEC
EXECUTE
EXISTS
EXIT
EXPLAIN
EXTENT
EXTERNALLY
FALSE
FETCH
FILE
FLOAT
FLUSH
FOR
FORCE
FOREIGN
FORM
FORTRAN
FOUND
FREELIST
FREELISTS
FROM
FUNCTION
GEN
GENERIC
GO
GOTO
GRANT
GROUP
GROUPS
HAVING
IDENTIFIED
IF
IMMEDIATE
IN
INCLUDING
INCREMENT
INDEX
INDEXES
INDICATOR
INITIAL
INITRANS
INSERT
INSTANCE
INT
INTEGER
INTERSECT
INTO
IS
KEY
KP
L
LANGUAGE
LAYER
LEVEL
LIKE
LIMITED
LINK
LISTS
LOCK
LOGFILE
LONG
LOOP
MANAGE
MANUAL
MAX
MAXDATAFILES
MAXEXTENTS
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAXTRANS
MAXVALUE
MIN
MINEXTENTS
MINUS
MINVALUE
MLSLABEL
MOD
MODE
MODIFY
MODULE
MOUNT
NA
NATURAL
NC
ND
NEW
NEXT
NEXTVAL
NL
NM
NOARCHIVELOG
NOAUDIT
NOCACHE
NOCOMPRESS
NOCYCLE
NOMAXVALUE
NOMINVALUE
NONE
NOORDER
NORESETLOGS
NORMAL
NOSORT
NOT
NOTFOUND
NOWAIT
NR
NS
NT
NULL
NUMBER
NUMBER_BASE
NUMERIC
NZ
O
OF
OFF
OFFLINE
OLD
ON
ONLINE
ONLY
OPEN
OPTIMAL
OPTION
OR
ORDER
OTHERS
OUT
OWN
PACKAGE
PARALLEL
PARTITION
PCTFREE
PCTINCREASE
PCTUSED
PLAN
PLI
POSITIVE
PRAGMA
PRECISION
PRIMARY
PRIOR
PRIVATE
PRIVILEGES
PROCEDURE
PROFILE
PUBLIC
QUOTA
RAISE
RANGE
RAW
READ
REAL
RECORD
RECOVER
REFERENCES
REFERENCING
RELEASE
REMR
RENAME
RESETLOGS
RESOURCE
RESTRICTED
RETURN
REUSE
REVERSE
REVOKE
ROLE
ROLES
ROLLBACK
ROW
ROWID
ROWLABEL
ROWNUM
ROWS
ROWTYPE
RUN
S
SAVEPOINT
SCHEMA
SCN
SECTION
SEGMENT
SELECT
SEPARATE
SEQUENCE
SESSION
SET
SHARE
SHARED
SIZE
SMALLINT
SNAPSHOT
SOME
SORT
SPACE
SQL
SQLBUF
SQLCODE
SQLERRM
SQLERROR
SQLSTATE
START
STATEMENT
STATEMENT_ID
STATISTICS
STDDEV
STOP
STORAGE
SUBTYPE
SUCCESSFUL
SUM
SWITCH
SYNONYM
SYSDATE
SYSTEM
TABAUTH
TABLE
TABLES
TABLESPACE
TASK
TEMPORARY
TERMINATE
THEN
THREAD
TIME
TO
TRACING
TRANSACTION
TRIGGER
TRIGGERS
TRUE
TRUNCATE
TTC
TYPE
UID
UNDER
UNION
UNIQUE
UNLIMITED
UNTIL
UPDATE
UPI
USE
USER
USING
VALIDATE
VALUES
VARCHAR
VARCHAR2
VARIANCE
VIEW
VIEWS
WHEN
WHENEVER
WHERE
WHILE
WITH
WORK
WRITE
XA
XOR

No comments:

Post a Comment

Your comment will be visible after approval.