Saturday 17 August 2013

RESERVED WORDS (PL/SQL)-Oracle 10g



 An asterisk (*) indicates words are also SQL Reserved Words.

 ALL*                                                     DESC*                   JAVA                          PACKAGE             SUBTYPE
 ALTER*                                                 DISTINCT*          LEVEL*                       PARTITION          SUCCESSFUL*
 AND*                                                    DO                         LIKE*                          PCTFREE*            SUM
 ANY*                                                     DROP*                 LIMITED                    PLS_INTEGER      SYNONYM*
 ARRAY                                                 ELSE*                    LOCK*                        POSITIVE              SYSDATE*
 AS*                                                        ELSIF                     LONG*                      POSITIVEN           TABLE*
 ASC*                                                     END                      LOOP                          PRAGMA              THEN*
 AT                                                          EXCEPTION         MAX                           PRIOR*                 TIME
 AUTHID                                               EXCLUSIVE*      MIN                          PRIVATE               TIMESTAMP
 AVG                                                      EXECUTE              MINUS*                   PROCEDURE       TIMEZONE_ABBR
 BEGIN                                                   EXISTS*               MINUTE                    PUBL IC*            TIMEZONE_HOUR
 BETWEEN*                                          EXIT                      MLSLABEL*              RAISE            TIMEZONE_MINUTE
BINARY_INTEGER  EXTENDS         MOD                    RANGE                      TIMEZONE_REGION
BODY                                                     EXTRACT              MODE*                      RAW*                TO*
 BOOLEAN                                            FALSE                   MONTH                      REAL                 TRIGGER*
 BULK                                                    FETCH                   NATURAL                  RECORD          TRUE
 BY*                                                       FLOAT*                NATURALN              REF                    TYPE
 CHAR*                                                 FOR*                     NEW                           RELEASE            UI
 CHAR_BASE                                       FORALL                 NEXTVAL                  RETURN            UNION*
 CHECK*                                               FROM*                 NOCOPY                   REVERSE           UNIQUE*
 CLOSE                                                  FUNCTION          NOT*                         ROLLBACK        UPDATE*
 CLUSTER*                                           GOTO                    NOWAIT*                 ROW*               USE
 COALESCE                                          GROUP*              NULL*                        ROWID*           USER*
 COLLECT                                              HAVING*            NULLIF                       ROWNUM*      VALIDATE*
 COMMENT*                                      HEAP                     NUMBER*                ROWTYPE         VALUES*
 COMMIT                                             HOUR                    NUMBER_BASE      SAVEPOINT       VARCHAR*
 COMPRESS*                                      IF                            OCIROWID               SECOND          VARCHAR2*
 CONNECT*                                                        IMMEDIATE*      OF*                           SELECT*             VARIANCE
 CONSTANT                                                        IN*                         ON*                           SEPERATE          VIEW*
 CREATE*                                              INDEX*                OPAQUE                   SET*                  WHEN
 CURRENT*                                       INDICATOR           OPEN                         SHARE*             WHENEVER*
 CURRVAL                                          INSERT*                 OPERATOR               SMALLINT*       WHERE*
 CURSOR                                           INTEGER*               OPTION*                  SPACE                 WHILE
 DATE*                                               INTERFACE             OR*                            SQL                     WITH*
 DAY                                                   INTERSECT*            ORDER*                   SQLCODE            WORK
 DECIMAL*                                     INTERVAL        ORGANIZATION              SQLERRM         WRITE
 DECLARE                                       INTO*               OTHERS                               START*               YEAR
 DEFAULT*                                     IS*                    OUT                                       STDDEV             ZONE
 DELETE*                                        ISOLATION

No comments:

Post a Comment