A P P E N D I X ÿ ÿ B

Cuvinte rezervate SQL

Urmatoarele cuvinte sunt rezervate SQL.Nu puteti sa le utilizati ca nume de obiecte de tip baza de date daca nu sunt puse intre ghilimle.

Cuvintele urmate de un asterix(*) sunt de asemenea cuvinte ANSI rezervate.


          ACCESS         DISTINCT*      IS*

          ADD            DROP

          ALL*                          LEVEL*

          ALTER          ELSE*          LIKE*

          AND*           EXCLUSIVE      LOCK

          ANY*           EXISTS*        LONG

          AS*

          ASC*           FILE           MAXEXTENTS

          AUDIT          FLOAT*         MINUS

                         FOR*           MODE

          BETWEEN*       FROM*          MODIFY*

          BY*                           NOAUDIT

                         GRANT*

          CHAR*                         NOCOMPRESS

          CHECK*         GROUP          NOT

          CLUSTER                       NOWAIT

          COLUMN         HAVING*        NULL*

          COMMENT                       NUMBER

          COMPRESS       IDENTIFIED

          CONNECT                       OF*

          CREATE*        IMMEDIATE*     OFFLINE

          CURRENT*       IN*            ON*

                         INCREMENT      ONLINE

          DATE           INDEX          OPTION*

          DBA            INITIAL        OR*

          DECIMAL*       INSERT*        ORDER*

          DEFAULT*       INTEGER*

          DELETE*        INTERSECT*     PCTFREE

          DESC*          INTO*          PRIOR*

          PRIVILEGES     TABLE*

          PUBLIC*        THEN*

                         TO*

          RAW            TRIGGER*

          RENAME

          RESOURCE       UID

          REVOKE*        UNION*

          ROW*           UNIQUE*

          ROWID          UPDATE*

          ROWNUM         USER*

          ROWS*

          ROWLABEL       VALIDATE

          SELECT*        VALUES*

          SESSION*       VARCHAR*

          SET*           VARCHAR2

          SHARE          VIEW*

          SIZE

          SMALLINT*      WHENEVER*

          START          WHERE*

          SUCCESSFUL     WITH*

          SYNONYM

          SYSDATE





Cuvinte cheie

Urmatoarele cuvinte cheie au o semnificatie speciala in limbajul SQL suportat de ORACLE RDBMS dar nu sunt cuvinte rezervate si astfel pot fi folosite ca identificatori.Aceste cuvinte pot deveni cuvinte rezervate in viitor.

Cuvintele rezervate ANSI sunt indicate printr-un *;cuvintele cheie adaugate in versiunea 6.0 sunt indicate prin +.


          ARCHIVELOG+         END+           MXVALUE+

          AUTHORIZATION*+     ESCAPE         MINEXTENTS

                              EVENTS+        MINVALUE

          BACKUP+             EXEC*+         MOUNT+

          BEGIN*+                            MODULE+

                              FETCH*+

          CACHE+              FOREIGN*+      NEXT*+

          CHARACTER*+         FORTRAN*+      NOARCHIVELOG+

          CLOSE*+             FOUND*+        NOCACHE+

          COBOL*+                            NOCYCLE+

          COMMIT*+            GO*+           NOMAXVALUE+

          CONSTRAIN*+         GOTO*+         NOMINVALUE+

          CONTENTS+                          NOORDER+

          CONTINUE*+          INCLUDING+     NORMAL+

          CONTROLFILE+        INDICATOR*+    NOSORT+

          CRASH               INITRANS+      NUMERIC*+

          CURSOR*+            INT*+

                                             ONLY*+

          CYCLE+              KEY*+          OPEN*+

          DATABASE            LANGUAGE*+

          DATAFILE+           LINK           PASCAL*+

          DEC*+               LOGFILE+       PCTINCREASE+

          DECLARE*+                          PCTUSED+

          DISMOUNT+           MAXDATAFILE+   PL1*+

          DOUBLE*+            MAXINSTANCES+  PRECISION*+

                              MAXLOGFILES+   PRIMARY*+

                              MAXTRANS+      PROCEDURE*+

          READ*+              SQLCOD*+

          REAL*+              SQLERROR*+

          REFERENCES*+        STATEMENT+

          RELEASE+            STORAGE+

          RESETLOGS           SWITCH+

          REUSE+              SYSTEM+

          ROLLBACK+



  SAVEPOINT+  TABLES+

  SCHEME      TABLESPACE+

  SECTION*+   TEMPORARY*+

  SEGMENT+    TEMPORARY*+

  SEQUENCE+

  SHARED+     USING*+

  SOME*+

  SORT+       WRITE*+

  SPECIFIED+  WORK*+

  SQL*+

PL/SQL Cuvinte rezervate

Urmatoarele cuvinte sunt rezervate si nu trebuie folosite ca nume pentru obiecte database sau ca identificatori in PL/SQL.


 ABORT
 ACCEPT
 ACCESSADD
 ALL
 ALTER
 AND
 ANY
 ARRAY
 AS
 ASC
 ASSERT
 ASSIGN
 AT
 AUTHORIZATION
 AVG

 BEGIN
 BETWEEN
 BODY
 BOOLEAN
 BY

 CASE
 CHAR
 CHAR_BASE
 CHECK
 CLOSE
 CLUSTER
 CLUSTERS
 COLAUTH
 COLUMNS
 COMMIT
 COMPRESS
 CONNECT
 CONSTANT
 COUNT
 CRASH

                DATA_BASE
 CREATE         DATABASE
 CURRENT        DATE
 CURSOR         DBA
                DEBUGOFF
                DEBUGON
                DECLARE
                DEFAULT
                DEFINITION
                DELAY
                DELETE
                DELTA
                DESC
                DIGITS
                DISPOSE
                DISTINCT
                DO
                Document Summary:
                DROP

                ELSE
                ELSIF
                END
                ENTRY
                EXCEPTION_INIT
                EXCEPTION
                EXISTS
                EXIT
                FALSE
                FETCH

                FOR
                FORM
                FROM
                FUNCTION

                GENERIC
                GOTO
                GRANT
                GROUP
                         HAVING
               IDENTIFIED
               IF
               IN
               INDEX
               INDEXES
               INDICATOR
               INSERT
               INTERSECT
               INTO
               IS

               LEVEL
               LIKE
               LIMITED
               LOOP

               MAX
               MIN
               MINUS
               MOD

               NEW
               NOCOMPRESS
               NOT
               NULL
               NUMBER
               NUMBER_BASE

               OF
               ON
               OPEN
               OPTION
               OR
               ORDER
               OTHERS
               OUT


 PACKAGE       TABAUTH
 PARTITION     TABLE
 PCTFREE       TABLES
 PRAGMA        TASK
 PRIOR         TERMINATE
 PRIVATE       THEN
 PROCEDURE     TO
 PUBLIC        TRUE
               TIPE

 RAISE
 RANGE         UNION
 RECORD        UNIQUE
 RELEASE       UPDATE
 REM           USE
 RENAME
 RESOURCE
 RETURN        VALUES
 REVERSE       VARCHAR
 REVOKE        VARCHAR2
 ROLLBACK      VARIANCE
 ROWNUM        VIEW
 ROWTYPE       VIEWS
 RUN

               WHEN
 SAVEPOINT     WHERE
 SCHEMA        WHILE
 SELECT        WHILE
 SEPARATE      WITH
 SET           WITH
 SIZE          WORK
 SPACE
 SQL
 SQLCODE       XOR
 SQLERRM
 START
 STATEMENT
 STDDEV
 SUBTYPE
 SUM