What is a public synonym?
- 1 Answers
- 1898 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 is difference between cartesian join & cross join even they give same result?
where do i find oracle interview questions.
What are the values that can be specified for OPTIMIZER MODE Parameter ?
How to fetch the row which has the max value for a column?
How to rename a tablespace in oracle?
What is Partitions in Table ?
What is user managed backup in Oracle?
How to rename an existing table?
difference between imlicit cursor and explicit cursor ?
What is partitioned table in Oracle?
Explain the difference between sql and oracle?
What is the diff between Oracle and SQL Server
Oracle General 
