VERIFIED SOLUTION i
X

MapInfo Professional™, MapMarker™ - Oracle and reserved words

UPDATED: April 21, 2017


PB products such as MapInfo Professional and MapMarker have the ability to connect to Oracle Databases.
Here is a list of reserved words, key words, and namespaces to note when connecting to Oracle databases.

From http://docs.oracle.com/cd/B28359_01/appdev.111/b31231/appb.htm

 

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

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.

Oracle Reserved Words

ACCESS

ELSE

MODIFY

START

ADD

EXCLUSIVE

NOAUDIT

SELECT

ALL

EXISTS

NOCOMPRESS

SESSION

ALTER

FILE

NOT

SET

AND

FLOAT

NOTFOUND

SHARE

ANY

FOR

NOWAIT

SIZE

ARRAYLEN

FROM

NULL

SMALLINT

AS

GRANT

NUMBER

SQLBUF

ASC

GROUP

OF

SUCCESSFUL

AUDIT

HAVING

OFFLINE

SYNONYM

BETWEEN

IDENTIFIED

ON

SYSDATE

BY

IMMEDIATE

ONLINE

TABLE

CHAR

IN

OPTION

THEN

CHECK

INCREMENT

OR

TO

CLUSTER

INDEX

ORDER

TRIGGER

COLUMN

INITIAL

PCTFREE

UID

COMMENT

INSERT

PRIOR

UNION

COMPRESS

INTEGER

PRIVILEGES

UNIQUE

CONNECT

INTERSECT

PUBLIC

UPDATE

CREATE

INTO

RAW

USER

CURRENT

IS

RENAME

VALIDATE

DATE

LEVEL

RESOURCE

VALUES

DECIMAL

LIKE

REVOKE

VARCHAR

DEFAULT

LOCK

ROW

VARCHAR2

DELETE

LONG

ROWID

VIEW

DESC

MAXEXTENTS

ROWLABEL

WHENEVER

DISTINCT

MINUS

ROWNUM

WHERE

DROP

MODE

ROWS

WITH

 

 

Environment Details

Products affected: MapInfo Professional™, MapMarker™ 
 

Downloads

  • No Downloads