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 are the advantages of primary key over unique+notnull

7 Answers   Consultancy, LGS, Oracle,

---

While inserting 10 rows using procedure, if 3rd entry is having some error, what will be the output? How u will handle that error?

8 Answers   iFlex,

---

Can a composite key be null?

0 Answers  

---

Explain spool.

0 Answers  

---

How to add a column ‘salary’ to a table employee_details?

0 Answers  

---

diff b/w function and procedure?

9 Answers   iFlex,

---

what are the differences between char and varchar? : Sql dba

0 Answers  

---

In testing where do we use sql language and how it helps in testing?

2 Answers  

---

What is the need of a partition key?

0 Answers  

---

How would you hide a table in sql. ie the table can be only visible to its maker?

3 Answers  

---

What is an index and types of indexes. How many number of indexes can be used per table ?

12 Answers   Accenture, BirlaSoft, Cognizant, CTS, Symphony,

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---