What is the use of file param in imp command?

0 Answers  

---

What is varray?

0 Answers  

---

How to call a stored procedure inside a trigger? Give an example.

1 Answers   Exilant,

---

what is port in oracle? how is it related to database application.

0 Answers  

---

What is oracle rowcount?

0 Answers  

---

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

0 Answers  

---

How to update a table row with a record?

0 Answers  

---

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

---

difference between procedures and function?

7 Answers   IBM,

---

Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.

1 Answers  

---

difference between bind variable and variable

1 Answers   Attra,

---

What are various constraints used in SQL?

1 Answers   Polaris,

---