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