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 myisam? : Sql dba

0 Answers  

---

what are integrity rules?

0 Answers  

---

What is t sql used for?

0 Answers  

---

Which is faster view or stored procedure?

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

What are the various restrictions imposed on view in terms of dml?

0 Answers  

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

I have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement.

7 Answers   MTS,

---

What is nvarchar max in sql?

0 Answers  

---

what are the advantages a stored procedure? : Sql dba

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

Is postgresql a nosql database?

0 Answers  

---