Oracle Database - Naming convention

Card Puncher Data Processing

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

  • The length must be at least one character, and no more than 3O characters.
  • The first character must be a letter.
  • Names may include letters, numbers and the following special characters:
    • the dollar sign ($),
    • the underscore (_)
    • and the hash mark (or pound sign) (#)
  • Names cannot be reserved words such as SELECT, CREATE, etc,

Advanced

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

Prefix

Avoid using system Oracle prefixes such as:

  • SYS
  • ALL
  • DBA
  • GB$
  • NLS
  • ROLE
  • USER
  • V$





Discover More
Card Puncher Data Processing
Oracle Database - SAVEPOINT (of a transaction)

A savepoint is a user-declared intermediate marker within the context of a transaction. Internally, this marker resolves to an SCN. Savepoints divide a long transaction into smaller parts. If you use...
Card Puncher Data Processing
Oracle Database - Table

A table name must follow the naming convention of database object. Add DataType Create Table ...
Card Puncher Data Processing
Oracle Database - User (Account/Client)

A user is an entity that can be authenticated. A user can be a person or a software entity, such as a Java client. Each user is given a unique identity within a security realm. For efficient security management,...



Share this page:
Follow us:
Task Runner