oracle批量替换保留字,oracle中的保留字(Reserved Words) (转)

Reserved Words

The words listed in this appendix are reserved by PL/SQL. That is, they have a

special syntactic meaning to PL/SQL. So, you should not use them to name

program objects such as constants, variables, or cursors. Some of these words

(marked by an asterisk) are also reserved by SQL. So, you should not use them to

name schema objects such as columns, tables, or indexes.

ALL*

ALTER*

AND*

ANY*

ARRAY

AS*

ASC*

AT

AUTHID

AVG

BEGIN

BETWEEN*

BINARY_INTEGER

BODY

BOOLEAN

BULK

BY*

CHAR*

CHAR_BASE

CHECK*

CLOSE

CLUSTER*

COLLECT

COMMENT*

COMMIT

COMPRESS*

CONNECT*

CONSTANT

CREATE*

CURRENT*

CURRVAL

CURSOR

DATE*

DAY

DECLARE

DECIMAL*

DEFAULT*

DELETE*

DESC*

DISTINCT*

DO

DROP*

ELSE*

ELSIF

END

EXCEPTION

EXCLUSIVE*

EXECUTE

EXISTS*

EXIT

EXTENDS

FALSE

FETCH

FLOAT*

FOR*

FORALL

FROM*

FUNCTION

GOTO

GROUP*

HAVING*

HEAP

HOUR

IF

IMMEDIATE*

IN*

INDEX*

INDICATOR

INSERT*

INTEGER*

INTERFACE

INTERSECT*

INTERVAL

INTO*

IS*

ISOLATION

JAVA

LEVEL*

LIKE*

LIMITED

LOCK*

LONG*

LOOP

MAX

MIN

MINUS*

MINUTE

MLSLABEL*

MOD

MODE*

MONTH

NATURAL

NATURALN

NEW

NEXTVAL

NOCOPY

NOT*

NOWAIT*

NULL*

NUMBER*

NUMBER_BASE

OCIROWID

OF*

ON*

OPAQUE

OPEN

OPERATOR

OPTION*

OR*

ORDER*

ORGANIZATION

OTHERS

OUT

PACKAGE

PARTITION

PCTFREE*

PLS_INTEGER

POSITIVE

POSITIVEN

PRAGMA

PRIOR*

PRIVATE

PROCEDURE

PUBLIC*

RAISE

RANGE

RAW*

REAL

RECORD

REF

RELEASE

RETURN

REVERSE

ROLLBACK

ROW*

ROWID*

ROWNUM*

ROWTYPE

SAVEPOINT

SECOND

SELECT*

SEPARATE

SET*

SHARE*

SMALLINT*

SPACE

SQL

SQLCODE

SQLERRM

START*

STDDEV

SUBTYPE

SUCCESSFUL*

SUM

SYNONYM*

SYSDATE*

TABLE*

THEN*

TIME

TIMESTAMP

TO*

TRIGGER*

TRUE

TYPE

UID*

UNION*

UNIQUE*

UPDATE*

USE

USER*

VALIDATE*

VALUES*

VARCHAR*

VARCHAR2*

VARIANCE

VIEW*

WHEN

WHENEVER*

WHERE*

WHILE

WITH*

WORK

WRITE

YEAR

ZONE[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9650775/viewspace-923249/，如需转载，请注明出处，否则将追究法律责任。