What is the purpose of Synonym in oracle?
Synonym - A synonym is an alternate name given to an Oracle object like Table, view, stored procedure etc. They are most helpful to shorten the specification of long or complex object name specifically in views or shared tables.
Example:Create a public synonym (accessible to all users).
Create public synonym student
for app.student;
What is the purpose of Synonym in oracle?
- Synonym provide alias name for a table.
- Synonym hides name of the table.
- With Synonym, you can provide users with less complicated table name than the real one.
