B Reserved Words, Keywords, and Namespaces

This appendix contains the following topics:

Reserved Words and Keywords

Some words are reserved by Oracle. That is, they have a special meaning to Oracle and cannot be redefined. For this reason, you cannot use them to name database objects such as columns, tables, or indexes. To view the lists of the Oracle reserved words for SQL and PL/SQL, see the Oracle Database SQL Language Reference and the Oracle Database PL/SQL Language Reference.

Pro*C/C++ keywords, like C or C++ keywords, should not be used as variables in your program. Otherwise, an error will be generated. An error may result if they are used as the name of a database object such as a column. Here are the keywords used in Pro*C/C++:

Table B-1 Pro*C and C++ Keywords

Keywords Keywords Keywords Keywords Keywords

all

allocate

alter

analyze

and

any

arraylen

as

asc

at

audit

authorization

avg

begin

between

bind

both

break

by

cache

call

cast

char

character

character

charf

charz

check

close

collection

comment

commit

connect

constraint

constraints

context

continue

convbufsz

count

create

current

currval

cursor

database

date

dateformat

datelang

day

deallocate

dec

decimal

declare

default

define

delete

deref

desc

describe

descriptor

display

distinct

do

double

drop

else

enable

end

endif

escape

exec

exec

execute

exists

explain

extract

fetch

float

flush

for

force

found

free

from

function

get

global

go

goto

grant

group

having

hour

iaf

identified

ifdef

ifndef

immediate

in

indicator

input

insert

integer

intersect

interval

into

is

is

leading

level

like

list

lob

local

lock

long

max

message

min

minus

minute

mode

month

multiset

nchar

nchar_cs

next

nextval

noaudit

not

notfound

nowait

null

number

numeric

nvarchar

nvarchar2

object

ocibfilelocator

ocibloblocator

ocicloblocator

ocidate

ociextproccontext

ocinumber

ociraw

ocirowid

ocistring

of

only

open

option

option

or

oracle

order

output

overlaps

package

partition

precision

prepare

prior

procedure

put

raw

read

real

ref

reference

register

release

rename

replace

return

returning

revoke

role

rollback

rowid

rownum

savepoint

second

section

select

set

set

smallint

some

sql

sql_context

sql_cursor

sqlerror

sqlwarning

start

statement

stddev

stop

string

sum

sysdate

sysdba

sysoper

table

temporary

the

threads

time

timestamp

timezone_hour

timezone_minute

to

tools

trailing

transaction

trigger

trim

truncate

type

uid

ulong_varchar

union

unique

unsigned

update

use

user

using

uvarchar

validate

values

varchar

varchar

varchar2

variables

variance

varnum

varraw

view

whenever

where

with

work

year

zone

-

-


Oracle Reserved Namespaces

The following table 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, do not use function names that begin with these characters. For example, the Oracle Net Transparent Network Service functions all begin with the characters NS, so you need to avoid naming functions that begin with NS.

Table B-2 Oracle Reserved Namespaces

Namespace Library

XA

external functions for XA applications only

SQ

external SQLLIB functions used by Oracle Precompiler and SQL*Module applications

O, OCI

external OCI functions internal OCI functions

UPI, KP

function names from the Oracle UPI layer

NA

NC

ND

NL

NM

NR

NS

NT

NZ

OSN

TTC

Oracle Net Native services product

Oracle Net RPC project

Oracle Net Directory

Oracle Net Network Library layer

Oracle Net Net Management Project

Oracle Net Interchange

Oracle Net Transparent Network Service

Oracle Net Drivers

Oracle Net Security Service

Oracle Net V1

Oracle Net Two task

GEN, L, ORA

Core library functions

LI, LM, LX

function names from the Oracle Globalization Support layer

S

function names from system-dependent libraries


The list in the table is not a comprehensive list of all functions within the Oracle reserved namespaces. For a complete list of functions within a particular namespace, refer to the document that corresponds to the appropriate Oracle library.