Database – Naming Standardization (Oracle)

Problem Statement: In tables can we use employee_name or emp_name?

Solution: This depends on organization. Many organizations follow emp_name.

Full Name Advantages:

  1. Easy to Read
  2. No Confusion


  1. Oracle supports only 30 char length column names
  2. Difficult to write queries at command prompt

Abbreviation Usage:

  1. Needs Abbreviation map to understand all column Names.
  2. Column Comments should help in this process.
  3. Easy to write queries
  4. Looks simple and easy to write and talk

Here with attached document from Oracle Site for your reference.





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.