B Reserved Words, Keywords, and Namespaces

This appendix contains the following topics:

Reserved Words and Keywords
Oracle Reserved Namespaces

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.