Synonyms
Creating and Dropping Synonyms
•
Creating a synonym eliminates the
need to qualify the object name with the schema and provides you with an
alternative name for a table, view, sequence, procedure, or other objects.
Syntax:
CREATE [PUBLIC] SYNONYM synonymname
FOR object;