Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Explain Connect by Prior?

Answers were Sorted based on User's Feedback



Explain Connect by Prior?..

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).

Is This Answer Correct ?    19 Yes 0 No

Explain Connect by Prior?..

Answer / guest

Retrives rows in hierarchical order.
e.g. select empno, ename from emp where

Is This Answer Correct ?    6 Yes 16 No

Post New Answer

More SQL PLSQL Interview Questions

Why do we use sql constraints?

0 Answers  


What is mutating error?

0 Answers  


Can we join two tables without common column?

0 Answers  


Why do we use procedures in sql?

0 Answers  


What is sql analyzer?

0 Answers  






What is a table partition?

0 Answers  


Does sql support programming?

0 Answers  


How do you explain an index?

0 Answers  


write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  


What is full form of rtm?

0 Answers  


What are tuples in sql?

0 Answers  


What are the two types of cursors in pl sql?

0 Answers  






Categories