What is a public synonym?
- 1 Answers
- 1756 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 |
how can we store any pdf file in oracle
What types of joins are used in writing subqueries?
How can we Update a table with out using UPDATE command?
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
Explain the relationship among Database, Tablespace and Data file?
What the is the diff between local index and global index. give some example.
what happened to the global index when I truncate the data in one of the partition?
Explain the function of optimizer in oracle?
How to create a new tablespace in oracle?
What is a trigger and what are its types?
what is the difference between data migration and production migration.
Is it possible to split the print reviewer into more than one region ?
Oracle General 
