Oracle glossary: synonyms

A synonym is an alias to a database object. It can help to reduce sql
complexity when written.
A public synonym is visible to any users.
A private synonym is contained and visible only to the creating user.
Some example:
DROP [PUBLIC] SYNONYM syn_table;
CREATE PUBLIC SYNONYM syn_table FOR anotherschema.table;
private synonym
CREATE SYNONYM syn_table FOR schema.table;

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *