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 |
T1: T2 A X--- this is updated record B B like this T1 table having no.of records updated. write a query"retrive updated record from T2"
Explain do view contain data?
How many types of synonyms in Oracle?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How to create DSN..Explain?
2 Answers Accenture, BeBo Technologies, Infosys,
what are stored procedures?
who is the father of oracle and send chodd rules
What are the uses of Database Trigger ?
Differentiate between function and procedure in oracle.
How to get a create statement for an existing table?
Explain the difference between sql and oracle?
what is the syntax of UPDATE command?