What is a synonym? What are its various types?

synonym can be called as an alias for a table, view, sequence or program unit. It is basically of two types:
- Private - Only the owner can access it.
- Public - Can be accessed by any database user.

Posted in: 500 Oracle interview questions and answers