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;

Why do we need oracle client?

0 Answers  

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

0 Answers   EDC,

---

What is transaction control statement and how many types of transaction control statement in Oracle?

0 Answers   MCN Solutions,

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

Explain index?

0 Answers  

---

What is oracle sid?

0 Answers  

---

Explain the difference between a procedure and a function? What do you understand by those terms?

0 Answers  

---

Does oracle database need java?

0 Answers  

---

Respected sir, Please send me technical questions related to oracle apps..

0 Answers  

---

Can you create a synonym without having a table?

0 Answers  

---

What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

---

i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions

4 Answers   CGI,

---