What happens to the data files if a tablespace is dropped?

0 Answers  

---

How to retrieve data from an explicit cursor?

0 Answers  

---

What are oracle functions?

0 Answers  

---

We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.

2 Answers   IBM,

---

What is program global area (pga) in oracle?

0 Answers  

---

---

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.

1 Answers   Wipro,

---

How to invoke the original export import utilities?

0 Answers  

---

How to export several tables together?

0 Answers  

---

What is Public Database Link ?

1 Answers  

---

What is clustered table in Oracle?

0 Answers   MCN Solutions,

---

What are the factors causing the reparsing of SQL statements in SGA?

2 Answers  

---

Explain integrity constraint?

0 Answers  

---