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;

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"

2 Answers   Cognizant,

---

Explain do view contain data?

0 Answers  

---

How many types of synonyms in Oracle?

0 Answers   MCN Solutions,

---

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 Answers  

---

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

---

what are stored procedures?

7 Answers   TCS, Wells Fargo,

---

who is the father of oracle and send chodd rules

4 Answers   ME,

---

What are the uses of Database Trigger ?

0 Answers  

---

Differentiate between function and procedure in oracle.

0 Answers  

---

How to get a create statement for an existing table?

0 Answers  

---

Explain the difference between sql and oracle?

0 Answers  

---

what is the syntax of UPDATE command?

8 Answers  

---