Synonym

 A synonym us a database object, which is used as an alias for a table, view or sequence. They are used to

• Simplify SQL statements
• Mask the name and owner of an object
• Provide public access to an object

Synonyms can be either private or public. The former is created by the user, which is available only to that person whereas the latter is created by the DBA which can be a valid by any database user.

• Only DBA can create a public synonym

Syntax:- create synonym synonymname for tablename
Ex:-     create synonym visi for vision;
Select * from visi;

For
Online Classes

Contact Us: +919885348743