pls explain connect by prior with example and its real time use

3 Answers  

---

what is the syntax of DROP command?

10 Answers  

---

find out the third highest salary?

92 Answers   CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

Difference between cartesian join and cross join?

0 Answers  

---

---

What is a trace file and how is it created in oracle?

0 Answers  

---

Explain oracle instance.

0 Answers  

---

Whether any commands are used for months calculation? If so, what are they?

0 Answers  

---

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

1 Answers  

---

Give the advantages and disadvantages of clusters.

0 Answers  

---

What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,

---

what is cartesian product?

2 Answers  

---