Interested to Buy Any Domain ? << Click Here >> for more details...
What is a public synonym?
- 1 Answers
- 2455 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 to unbreak sequence numbers during intereptions
How do I find the database name in oracle?
how to find the second highest salary in a given table????
How to create a new table in your schema?
What is backup in Oracle?
Why we choose emp number as primarykey?
Select the Nth lowest value from a table?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
What is a subquery in oracle?
How to create a table index?
How remove data files before opening a database?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
Oracle General 
