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;

How to increment dates by 1 in oracle?

1 Answers  

---

How to enter a new row into a table interactively?

1 Answers  

---

What does COMMIT do ?

4 Answers  

---

How to create an oracle database manually?

1 Answers  

---

does the query needs a hint to access a materialized view?

1 Answers  

---

Explain database link?

1 Answers  

---

How to open a cursor variable?

1 Answers  

---

What is Redo Log Buffer in Oracle?

1 Answers   MCN Solutions,

---

How to display the hierarchy of employee and managers without using connect by prior.

1 Answers  

---

How do I know if oracle client is installed on windows?

1 Answers  

---

How will you identify oracle database software release?

1 Answers  

---

What is data file?

1 Answers  

---