Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain connect by prior with example and its real time
use
- 3 Answers
- 14499 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 is reindexing?
Can we store pictures in the database and if so, how it can be done?
What is a cursor in oracle?
How to add a new column to an existing table in oracle?
What are the type of Synonyms?
State the various uses of dbcc command?
How to loop through a cursor variable?
What is an oracle tablespace?
How to run create database statement again?
Why we use bulk collect in oracle?
Explain the use of rows option in imp command.
Give the various rollback segment states.
Oracle General 
