Synonyms

Synonyms

Synonyms are database objects that enable you to cll a table by another name.

• create an easier reference to a table that is owned by another user.
• shorten lengthy object name
• This method can be especially useful with lengthy object names, such as views.
  

syntax)

CREATE [PUBLIC] SYNONYMS synonym FOR object;

PUBLIC : creates a synonyms that is accessible to all users;

- The object cannot be contained in a package.
- A private synonym name must be distinct from all other object that are owned by the
  same user.

Creating and Removing Synonyms

ex)

CREATE SYNONYM d_sum FOR dept_sum_vu;

DROP SYNONYM d_sum;

CREATE PUBLIC SYNONYM dept FOR alice.departments;

DROP PUBLIC SYNONYM dept;

- Only the database administrator can drop a public synonym.