Skip to main content
Skip table of contents

Database Reserved Words

On this page:

PowerSchool leverages Oracle, the leading 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


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.