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 difference between function and trigger?

0 Answers  

---

What is a memo field?

0 Answers  

---

What are the indexing methods?

0 Answers  

---

How do you drop a trigger?

0 Answers  

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

What is rtm in testing?

0 Answers  

---

what is the difference between union and union all? : Sql dba

0 Answers  

---

How many sql databases can you have on one server?

0 Answers  

---

What is hibernate and its relation to sql?

0 Answers  

---

hi this is nakka i have been looking for 1+ exp in oracle sql,plsql developer positions also have knoledge on d2k i am not getting proper walkins how to know it? where can i find it?

5 Answers  

---

What are pl/sql cursors?

0 Answers  

---