What is a public synonym?
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 to rename a tablespace in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
how to handle exceptions in post production
How to create id with auto_increment on oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
what are the things that you consider while creating indexes on partitioning tables?
What a SELECT FOR UPDATE cursor represent.?
how to delete all duplicate records from a table using subquery?
Whats the benefit of dbms_stats over analyze?
What are the numeric comparison operations?
Explain mutating triggers.
What happens in oracle commit?