Interested to Buy Any Domain ? << Click Here >> for more details...
What is a public synonym?
- 1 Answers
- 2519 Views
- I also Faced
- E-Mail Answers
Answer / basanti
Synonym is an alias for a object of a database.
It can be created for TABLE or VIEW.
There are two type of synonym PRIVATE and PUBLIC.
public synonym is created by a keyword public.
public synonym is accessible to any schema in the database.
Syntax to create public synonym:
CREATE PUBLIC SYNONYM synonym_name FOR object_name;
| Is This Answer Correct ? | 0 Yes | 0 No |
What happens if you lost a data file?
What is Undo Management Advisor in Oracle?
What is a trigger and what are its types?
What is cluster Key ?
Explain the use of compress option in exp command.
How to create a new user account in oracle?
State some uses of redo log files?
How to join two tables in a single query using oracle?
What is format trigger?
Why do we need integrity constraints in a database?
What are joins, explain all types of joins?
How to write numeric literals in oracle?
Oracle General 
