Answer / abhijit

The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).


select a.*, level from emp a
start with mgr is null
connect by mgr = prior empno;

The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).

Answer / guest

Retrives rows in hierarchical order.
e.g. select empno, ename from emp where

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

Can we call procedure in select statement?

0 Answers  

---

How can analyze query after generating explain plan ?

2 Answers   Thermotech,

---

What are the benefits of using PL/SQL packages?

3 Answers  

---

What is the difference between a procedure and a function?

0 Answers  

---

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

0 Answers  

---

What is db journal file?

0 Answers  

---

Is join same as left join?

0 Answers  

---

What are different categories of sql commands?

0 Answers  

---

How do I find sql profiler?

0 Answers  

---

how to enter binary numbers in sql statements? : Sql dba

0 Answers  

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

0 Answers  

---