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

Define commit, rollback and savepoint?

0 Answers  

---

What are field types?

0 Answers  

---

What is pragma exception and how, when, where us

5 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

What is faster join or subquery?

0 Answers  

---

---

what is explain plan?, given an example...

3 Answers   Polaris,

---

What is sql*loader?

0 Answers  

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

0 Answers  

---

What is the purpose of cursors in pl/sql?

0 Answers  

---

What is varchar data type in sql?

0 Answers  

---

What is online transaction processing (oltp)?

0 Answers  

---

what is a trigger? : Sql dba

0 Answers  

---