Synonyms - Oracle

Synonyms

 

 

Simplify access to objects by creating a synonym (another name for an object). With synonyms, you can:

 

• Ease referring to a table owned by another user

• Shorten lengthy object names

 

Query syntax

 

CREATE [PUBLIC] SYNONYM synonym

FOR object;

Eg:

CREATE PUBLIC SYNONYM dept

FOR alice.departments;