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 |