DEVFYI - Developer Resource - FYI

What are synonyms used for?

ORACLE Interview Questions and Answers (Part 1)

(Continued from previous question...)

38. What are synonyms used for?

- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

(Continued on next question...)

Other Interview Questions