pls explain connect by prior with example and its real time use

pls explain connect by prior with example and its real time
use

Question Posted / guest

3 Answers
14656 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

pls explain connect by prior with example and its real time use..

Answer / anil kumar karasi

sql>Select rownum,rownid,level,empno,ename from emp
connect by prior empno=mgr where mgr is null;

o/p
Rownum Rowid Level empno ename
------ ----- ----- ----- -----
1 AABBBCCDA 1 5678 abcd
2 AABBBCCDB 1 9087 poiu
3 AABBBCCDC 2 8567 QWER
4 AABBBCCDD 2 7321 LKJH
5 AABBBCCDE 3 1284 ZXCV

For more details go through this link
http://www.psoug.org/reference/connectby.html

Is This Answer Correct ?

10 Yes

1 No

pls explain connect by prior with example and its real time use..

Answer / muhammed zaheer

Connect by prior can be used to create heirarchical tree
structure

Is This Answer Correct ?

6 Yes

3 No

pls explain connect by prior with example and its real time use..

Answer / simi

CONNECT BY PRIOR is used for tree-structured queries.
I found a simple & useful explanation here:
http://www.oraclepassport.com
SQL - CONNECT By PRIOR Section

Is This Answer Correct ?

4 Yes

2 No

Post New Answer

More Oracle General Interview Questions

What is a trigger oracle?

0 Answers

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers

What is object data modeling?

0 Answers

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

0 Answers Oracle,

Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle

0 Answers

when loggined as SYSTEM,how to display all the users of database using sql query?

2 Answers

How do you handle duplicate records in a database?

1 Answers

What is a named program unit?

0 Answers

What is an oracle table?

0 Answers

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

0 Answers

I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?

5 Answers Zensar,

How to create index-by table in oracle?

3 Answers

For more Oracle General Interview Questions Click Here