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

How many types of index are there?

0 Answers  

---

Are null values same as that of zero or a blank space?

0 Answers  

---

What is use of package in pl sql?

0 Answers  

---

what is timestamp in mysql? : Sql dba

0 Answers  

---

How does sql developer connect to oracle database?

0 Answers  

---

---

Explain the working of foreign key?

0 Answers  

---

What is an example of translating a date into julian format?

0 Answers  

---

What is the difference between join and natural join?

0 Answers  

---

How do I clear the screen in sql plus?

0 Answers  

---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

0 Answers  

---

What is sequence in sql?

0 Answers  

---

What is a table partition?

0 Answers  

---