SQL Plus - Explain CONNECT BY PRIOR

GeekInterview.com > Interview Questions > Oracle > SQL Plus

Go To First | Previous Question | Next Question

SQL Plus | Question 8 of 132

Explain CONNECT BY PRIOR

Total Answers and Comments: 3

Last Update: December 08, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 28, 2005 04:11:16

Swapnil

RE: Explain CONNECT BY PRIOR

it is used to get a tree type structure in data.

say like hierarchy in a company.. employees reporting their managers etc..

Is this answer useful? Yes | No

September 16, 2005 01:09:49

Atal

Member Since: September 2005 Contribution: 3

RE: Explain CONNECT BY PRIOR

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 useful? Yes | No

December 08, 2006 08:27:43

rampratap409

Member Since: September 2006 Contribution: 111

RE: Explain CONNECT BY PRIOR

select a.* level from emp a

start with mgr is null

connect by mgr prior empno;

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank