Table of Contents

Oracle Database - Naming convention

About

Below is the naming convention for database object

Uniqueness

Two objects can not have the same name in the same namespace. The namespace is normally the schema where the object is created excepted for an index because it has its own namespace within the schema. Therefore an index can have the same name than any other object in the same schema.

Case Sensitivity

All objects are case insensitive and are treated as upper-case letters if they are not enclosed between double quotation.

Naming Rules

Standard

Advanced

By using double quotation marks, you can include special characters such as space

Prefix

Avoid using system Oracle prefixes such as: