Database Reserved Words

PowerSchool leverages Oracle, a relational database management solution for enterprise applications. Oracle is an SQL-based database. SQL is a standard language that many applications use to communicate with database management systems. The PowerSchool application is written in Java and translates web requests to standard SQL statements that are sent to Oracle for processing.

The following 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 extensions.

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

Oracle Keywords

Admin	End	Min	Reuse
After	Escape	Minextents	Role
Allocate	Events	Minvalue	Roles
Analyze	Except	Module	Rollback
Archive	Exceptions	Mount	Savepoint
Archivelog	Exec	New	Schema
Authorization	Execute	Next	Scn
Avg	Explain	Noarchivelog	Section
Backup	Extent	Nocache	Segment
Become	Externally	Nocycle	Sequence
Before	Fetch	Nomaxvalue	Shared
Begin	Flush	Nominvalue	Snapshot
Block	Force	None	Some
Body	Foreign	Noorder	Sort
Cache	Fortran	Noresetlogs	Sql
Cancel	Found	Normal	Sqlcode
Cascade	Freelist	Nosort	Sqlerror
Change	Freelists	Numeric	Sqlstate
Character	Function	Off	Statement_Id
Checkpoint	Go	Old	Statistics
Close	Goto	Only	Stop
Cobol	Groups	Open	Storage
Commit	Including	Optimal	Sum
Compile	Indicator	Own	Switch
Constraint	Initrans	Package	System
Constraints	Instance	Parallel	Tables
Contents	Int	Pctincrease	Tablespace
Continue	Key	Pctused	Temporary
Controlfile	Language	Plan	Thread
Count	Layer	Pli	Time
Cursor	Link	Precision	Tracing
Cycle	Lists	Primary	Transaction
Database	Logfile	Private	Triggers
Datafile	Manage	Procedure	Truncate
Dba	Manual	Profile	Under
Dec	Max	Quota	Unlimited
Declare	Maxdatafiles	Read	Until
Disable	Maxinstances	Real	Use
Dismount	Maxlogfiles	Recover	Using
Double	Maxloghistory	References	When
Dump	Maxlogmembers	Referencing	Work
Each	Maxtrans	Resetlogs	Write
Enable	Maxvalue	Restricted

PL Or SQL Reserved Words

Abort	Between	Crash	Digits
Accept	Binary_Integer	Create	Dispose
Access	Body	Current	Distinct
Add	Boolean	Currval	Do
All	By	Cursor	Drop
Alter	Case	Database	Else
And	Char	Data_Base	Elsif
Any	Char_Base	Date	End
Array	Check	Dba	Entry
Arraylen	Close	Debugoff	Exception
As	Cluster	Debugon	Exception_Init
Asc	Clusters	Declare	Exists
Assert	Colauth	Decimal	Exit
Assign	Columns	Default	False
At	Commit	Definition	Fetch
Authorization	Compress	Delay	Float
Avg	Connect	Delete	For
Base_Table	Constant	Delta	Form
Begin	Count	Desc	From
Function	New	Release	Sum
Generic	Nextval	Remr	Tabauth
Goto	Nocompress	Rename	Table
Grant	Not	Resource	Tables
Group	Null	Return	Task
Having	Number	Reverse	Terminate
Identified	Number_Base	Revoke	Then
If	Of	Rollback	To
In	On	Rowid	True
Index	Open	Rowlabel	Type
Indexes	Option	Rownum	Union
Indicator	Or	Rowtype	Unique
Insert	Order	Run	Update
Integer	Others	Savepoint	Use
Intersect	Out	Schema	Values
Into	Package	Select	Varchar
Is	Partition	Separate	Varchar2
Level	Pctfree	Set	Variance
Like	Positive	Size	View
Limited	Pragma	Smallint	Views
Loop	Prior	Space	When
Max	Private	Sql	Where
Min	Procedure	Sqlcode	While
Minus	Public	Sqlerrm	With
Mlslabel	Raise	Start	Work
Mod	Range	Statement	Xor
Mode	Real	Stddev
Natural	Record	Subtype

Java

The following Java keywords cannot be used as extension names.

Abstract	Else	Interface	Switch
Assert	Enum	Long	Synchronized
Boolean	Extends	Native	Switch
Break	False	New	Synchronized
Byte	Final	Null	This
Case	Finally	Package	Throw
Catch	Float	Private	Throws
Char	For	Protected	Transient
Class	Goto	Public	True
Const	If	Return	Try
Continue	Implements	Short	Void
Default	Import	Static	Volatile
Do	Instanceof	Strictfp	While
Double	Int	Super