pls explain connect by prior with example and its real time
use
- 3 Answers
- 13809 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Connect by prior can be used to create heirarchical tree
structure
| Is This Answer Correct ? | 6 Yes | 3 No |
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 |
What are dml statements in oracle?
What operating systems are supported by oracle database 10g xe?
How do you handle duplicate records in a database?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
what is query and types of query
How do I find the database name in oracle?
What is connection pool in oracle?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How will you write a query to get a 5th rank student from a table student_report?
Can we store images in oracle database?
query to find the maximum no persons with same age(age colomn) from emp table
Oracle General 
