Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How are extents allocated to a segment?
Explain compound trigger in oracle?
What is bulk copy or bcp in oracle?
How many types of cluster table in Oracle?
How to invoke the original export import utilities?
How is it different from a normal table?
What is format trigger?
What do database buffers contain?
How to do a full database export?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is tns name?
List out the difference between commit, rollback, and savepoint?
What is blob data type in oracle?
How to specify default values in insert statement using oracle?
How to run queries on external tables?
