Oracle - Reserved Words, Keywords, and Namespaces



Desenvolvido por DORNELLES Carlos Alberto - Analista de Sistemas - Brasília DF. - cad_cobol@hotmail.com

Oracle - Reserved Words, Keywords, and Namespaces - palavras reservadas, palavras-chave e namespaces

Este apêndice lista palavras que têm um significado especial para o Oracle.

Cada palavra desempenha um papel específico no contexto em que aparece.

Por exemplo, em uma instrução INSERT, a palavra reservada INTO apresenta as tabelas às quais as linhas serão adicionadas.

Mas, em uma instrução FETCH ou SELECT, a palavra reservada INTO introduz as variáveis ??do host de saída às quais os valores da coluna serão atribuídos.

This appendix lists words that have a special meaning to Oracle.

Each word plays a specific role in the context in which it appears.

For example, in an INSERT statement, the reserved word INTO introduces the tables to which rows will be added.

But, in a FETCH or SELECT statement, the reserved word INTO introduces the output host variables to which column values will be assigned.


Oracle Reserved Words

As palavras a seguir são reservadas pela Oracle.

Ou seja, eles têm um significado especial para a Oracle e, portanto, não podem ser redefinidos.

Por esse motivo, você não pode usá-los para nomear objetos de banco de dados, como colunas, tabelas ou índices.

The following words are reserved by Oracle.

That is, they have a special meaning to Oracle and so cannot be redefined.


For this reason, you cannot use them to name database objects such as columns, tables, or indexes.


ACCESS
ADD
ALL
ALTER
AND
ANY
ARRAYLEN
AS
ASC
AUDIT
BETWEEN
BY
CHAR
CHECK
CLUSTER
COLUMN
COMMENT
COMPRESS
CONNECT
CREATE
CURRENT
DATE
DECIMAL
DEFAULT
DELETE
DESC
DISTINCT
DROP
ELSE
EXCLUSIVE
EXISTS
FILE
FLOAT
FOR
FROM
GRANT
GROUP
HAVING
IDENTIFIED
IMMEDIATE
IN
INCREMENT
INDEX
INITIAL
INSERT
INTEGER
INTERSECT
INTO
IS
LEVEL
LIKE
LOCK
LONG
MAXEXTENTS
MINUS
MODE
MODIFY
NOAUDIT
NOCOMPRESS
NOT
NOTFOUND
NOWAIT
NULL
NUMBER
OF
OFFLINE
ON
ONLINE
OPTION
OR
ORDER
PCTFREE
PRIOR
PRIVILEGES
PUBLIC
RAW
RENAME
RESOURCE
REVOKE
ROW
ROWID
ROWLABEL
ROWNUM
ROWS
SELECT
SESSION
SET
SHARE
SIZE
SMALLINT
SQLBUF
START
SUCCESSFUL
SYNONYM
SYSDATE
TABLE
THEN
TO
TRIGGER
UID
UNION
UNIQUE
UPDATE
USER
VALIDATE
VALUES
VARCHAR2
VARCHAR
VIEW
WHENEVER
WHERE
WITH

Oracle Keywords

As palavras a seguir também têm um significado especial para o Oracle, mas não são palavras reservadas e, portanto, podem ser redefinidas.

No entanto, algumas podem eventualmente se tornar palavras reservadas.

The following words also have a special meaning to Oracle but are not reserved words and so can be redefined.

However, some might eventually become reserved words.


ADMIN
AFTER
ALLOCATE
ANALYZE
ARCHIVE
ARCHIVELOG
AUTHORIZATION
AVG
BACKUP
BECOME
BEFORE
BEGIN
BLOCK
BODY
CACHE
CANCEL
CASCADE
CHANGE
CHARACTER
CHECKPOINT
CLOSE
COBOL
COMMIT
COMPILE
CONSTRAINT
CONSTRAINTS
CONTENTS
CONTINUE
CONTROLFILE
COUNT
CURSOR
CYCLE
DATABASE
DATAFILE
DBA
DEC
DECLARE
DISABLE
DISMOUNT
DOUBLE
DUMP
EACH
ENABLE
END
ESCAPE
EVENTS
EXCEPT
EXCEPTIONS
EXEC
EXECUTE
EXPLAIN
EXTENT
EXTERNALLY
FETCH
FLUSH
FORCE
FOREIGN
FORTRAN
FOUND
FREELIST
FREELISTS
FUNCTION
GO
GOTO
GROUPS
INCLUDING
INDICATOR
INITRANS
INSTANCE
INT
KEY
LANGUAGE
LAYER
LINK
LISTS
LOGFILE
MANAGE
MANUAL
MAX
MAXDATAFILES
MAXINSTANCES
MAXLOGFILES
MAXLOGHISTORY
MAXLOGMEMBERS
MAXTRANS
MAXVALUE
MIN
MINEXTENTS
MINVALUE
MODULE
MOUNT
NEW
NEXT
NOARCHIVELOG
NOCACHE
NOCYCLE
NOMAXVALUE
NOMINVALUE
NONE
NOORDER
NORESETLOGS
NORMAL
NOSORT
NUMERIC
OFF
OLD
ONLY
OPEN
OPTIMAL
OWN
PACKAGE
PARALLEL
PCTINCREASE
PCTUSED
PLAN
PLI
PRECISION
PRIMARY
PRIVATE
PROCEDURE
PROFILE
QUOTA
READ
REAL
RECOVER
REFERENCES
REFERENCING
RESETLOGS
RESTRICTED
REUSE
ROLE
ROLES
ROLLBACK
SAVEPOINT
SCHEMA
SCN
SECTION
SEGMENT
SEQUENCE
SHARED
SNAPSHOT
SOME
SORT
SQL
SQLCODE
SQLERROR
SQLSTATE
STATEMENT_ID
STATISTICS
STOP
STORAGE
SUM
SWITCH
SYSTEM
TABLES
TABLESPACE
TEMPORARY
THREAD
TIME
TRACING
TRANSACTION
TRIGGERS
TRUNCATE
UNDER
UNLIMITED
UNTIL
USE
USING
WHEN
WORK
WRITE

PL/SQL Reserved Words

As seguintes palavras-chave PL/SQL podem requerer tratamento especial quando usadas em instruções SQL embutidas.

The following PL/SQL keywords may require special treatment when used in embedded SQL statements.


ABORT
ACCEPT
ACCESS
ADD
ALL
ALTER
AND
ANY
ARRAY
ARRAYLEN
AS
ASC
ASSERT
ASSIGN
AT
AUTHORIZATION
AVG
BASE_TABLE
BEGIN
BETWEEN
BINARY_INTEGER
BODY
BOOLEAN
BY
CASE
CHAR
CHAR_BASE
CHECK
CLOSE
CLUSTER
CLUSTERS
COLAUTH
COLUMNS
COMMIT
COMPRESS
CONNECT
CONSTANT
COUNT
CRASH
CREATE
CURRENT
CURRVAL
CURSOR
DATABASE
DATA_BASE
DATE
DBA
DEBUGOFF
DEBUGON
DECIMAL
DECLARE
DEFAULT
DEFINITION
DELAY
DELETE
DELTA
DESC
DIGITS
DISPOSE
DISTINCT
DO
DROP
ELSE
ELSIF
END
ENTRY
EXCEPTION
EXCEPTION_INIT
EXISTS
EXIT
FALSE
FETCH
FLOAT
FOR
FORM
FROM
FUNCTION
GENERIC
GOTO
GRANT
GROUP
HAVING
IDENTIFIED
IF
IN
INDEX
INDEXES
INDICATOR
INSERT
INTEGER
INTERSECT
INTO
IS
LEVEL
LIKE
LIMITED
LOOP
MAX
MIN
MINUS
MLSLABEL
MOD
MODE
NATURAL
NEW
NEXTVAL
NOCOMPRESS
NOT
NULL
NUMBER
NUMBER_BASE
OF
ON
OPEN
OPTION
OR
ORDER
OTHERS
OUT
PACKAGE
PARTITION
PCTFREE
POSITIVE
PRAGMA
PRIOR
PRIVATE
PROCEDURE
PUBLIC
RAISE
RANGE
REAL
RECORD
RELEASE
REMR
RENAME
RESOURCE
RETURN
REVERSE
REVOKE
ROLLBACK
ROWID
ROWLABEL
ROWNUM
ROWTYPE
RUN
SAVEPOINT
SCHEMA
SELECT
SEPARATE
SET
SIZE
SMALLINT
SPACE
SQL
SQLCODE
SQLERRM
START
STATEMENT
STDDEV
SUBTYPE
SUM
TABAUTH
TABLE
TABLES
TASK
TERMINATE
THEN
TO
TRUE
TYPE
UNION
UNIQUE
UPDATE
USE
VALUES
VARCHAR2
VARCHAR
VARIANCE
VIEW
VIEWS
WHEN
WHERE
WHILE
WITH
WORK
XOR

Oracle Reserved Namespaces

Contém uma lista de namespaces reservados pela Oracle.

Os caracteres iniciais dos nomes das funções nas bibliotecas Oracle são restritos às cadeias de caracteres nesta lista.

Devido a possíveis conflitos de nome, use nomes de função que não comecem com esses caracteres.

Por exemplo, todas as funções do Serviço de Rede Transparente SQL * Net começam com os caracteres "NS", portanto, você deve evitar nomear funções que comecem com "NS".

Contains a list of namespaces that are reserved by Oracle.

The initial characters of function names in Oracle libraries are restricted to the character strings in this list.

Because of potential name conflicts, use function names that do not begin with these characters.

For example, the SQL*Net Transparent Network Service functions all begin with the characters "NS," so you need to avoid naming functions that begin with "NS."


Namespace Library
O OCI functions
S function names from SQLLIB and system-dependent libraries
XA external functions for XA applications only
GEN KP L NA NC ND NL NM NR NS NT NZ TTC UPI Internal functions