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 define a specific record type?

0 Answers  

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

How do I limit the number of rows returned by an oracle query after ordering?

0 Answers  

---

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,

---

How to install oracle odbc drivers?

0 Answers  

---

---

What is use of oracle?

2 Answers   Satyam,

---

Is primary key = unique key,not null? If yes,please explain IF No,please explain

8 Answers   Genpact,

---

What is the difference between substr & instr functions?

0 Answers  

---

How to create tables for odbc connection testing?

0 Answers  

---

Write a syntax for update query in oracle?

0 Answers  

---

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---

Can you tell me how to add new column in existing views?how?How is possible?

0 Answers   FIS,

---