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
BogSoft 1999