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 to use values from other tables in update statements using oracle?
How to start an oracle instance?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to select all columns of all rows from a table in oracle?
What is oracle latest version?
How to put more than 1000 values into an oracle in clause?
Design database draw er diagram for a certain scenario ?
How to write a left outer join with the where clause in oracle?
