Skip Headers
Pro*C/C++ Programmer's Guide
12c Release 1 (12.1)

E18408-11
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

A 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++:

Keywords Keywords Keywords
all allocate alter
analyze and any
append arraylen as
asc assign at
audit authorization avg
begin between bind
both break buffer
buffering by call
cast char character
character_set_name charf charz
check chunksize close
collection comment commit
connect constraint constraints
context continue convbufsz
copy count create
current currval cursor
data database date
dateformat datelang datetime_interval_code
datetime_interval_precision day deallocate
dec decimal declare
default define delete
deref desc describe
descriptor directory disable
display distinct do
double drop eject
else enable end
endif end-exec erase
escape exec execute
exists explain extract
fetch file fileexists
filename first float
flush for force
found free from
function get global
go goto grant
group having hold
host_stride_length hour iaf
identified ifdef ifndef
immediate in include
indicator indicator_stride_length input
insert integer internal_length
intersect interval into
is isopen istemporary
last leading length
level like list
load lob local
lock long max
message min minus
minute mode month
multiset name national_character
nchar nchar_cs next
     
nextval noaudit not
notfound nowait null
nullable number numeric
nvarchar nvarchar2 object
ocibfilelocator ocibloblocator ocicloblocator
ocidate ociextproccontext ocinumber
ociraw ocirowid ocistring
octet_length of one
only open option
or oracle order
output overlaps overpunch
package partition perform
precision prepare prior
procedure put raw
read real ref
reference register release
rename replace return
returned_length returned_octet_length returning
revoke role rollback
rowid rownum savepoint
scale second section
select set skip1
skip2 skip3 smallint
some sql sql-context
sql-cursor sqlerror sqlwarning
start statement stddev
stop string sum
sysdate sysdba sysoper
table temporary threads
time timestamp timezone_hour
timezone_minute to tools
title trailing transaction
trigger trim truncate
type uid ulong_varchar
union unique unsigned
user_defined_type_name user_defined_type_name_length user_defined_type_schema
user_defined_type_schema_length user_defined_type_version update
use user using
validate value values
var varchar varchar2
variables variance varnum
varraw view whenever
where with work
write 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 A-1 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.