Interested to Buy Any Domain ? << Click Here >> for more details...
pls explain connect by prior with example and its real time
use
- 3 Answers
- 14555 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 would you do with an in-doubt distributed transaction?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
Is java required for oracle client?
what is the difference between oracle enterprise edition and oracle express edition?
What are a query and state the different types of queries and their uses?
Is it possible to disable the parameter from while running the report ?
What is the use of aggregate functions in oracle?
How to check your oracle database 10g xe installation?
Find all employees in Dept “Marketing”.
What are the factors causing the reparsing of SQL statements in SGA?
which language is used to develop the oracle........?
Write a syntax for update query in oracle?
Oracle General 
