pls explain connect by prior with example and its real time
use
- 3 Answers
- 13275 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 |
Youre getting high busy buffer waits - how can you find whats causing it?
Differentiate between translate and replace?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
Explain a private synonyms?
What privilege is needed for a user to delete rows from tables in another schema?
What are the factors causing the reparsing of SQL statements in SGA?
What are the various constraints used in oracle?
What are the types of trigger in oracle?
How to get maxsal , minsal, ename department wise in single query
Please explain the difference between outer join and inner join? With examples would be appreciable..!
Can select statements be used on views in oracle?
What is meant by a deadlock situation?
Oracle General 
