Synonym

A Synonym is a database object , which is used as an alias [alternative name] for a table, view, sequence . They are are used to

· Simplify the SQL statemnt.
· Hide the name and owner of an object
· Provide Location transparency for remote objects of a distributed database.
· Provide public access to an object.

Synonym can either be private or public

Public synonyms are created by a Database Administrator to hide the identity of a base table and reduce the complexity of SQL statement .

Data Dictionary Table for synonym User_Synonyms will provide details of synonyms that the user has created.