Answers

Question and Answer:

  Home  SQL and PL/SQL

⟩ What is Synonyms?

Synonyms is the alias name for table, views, sequences & procedures and are created for reasons of Security and Convenience.

Two levels are Public - created by DBA & accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifying the owner and Flexibility to customize a more meaningful naming convention.

 132 views

More Questions for you: