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;

One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.

6 Answers   Polaris,

---

What is a user account in oracle?

0 Answers  

---

How to create a stored function in oracle?

0 Answers  

---

where we have to use ON clause and where we have to use USING clause in JOINS

2 Answers  

---

What is private procedure oracle?

0 Answers  

---

How to resolve name conflicts between variables and columns?

0 Answers  

---

What is Public Database Link ?

1 Answers  

---

what is the syntax of SELECT command?

6 Answers  

---

How to store pictures on to the database?

0 Answers  

---

What is Reduced List of Values?

0 Answers   iFlex,

---

Is oracle a programming language?

0 Answers  

---

I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?

2 Answers   Philips,

---