SQL Plus Question:
Please Explain Connect by Prior?
Answer:
Retrieves rows in hierarchical order.e.g. select empno, ename from emp where.
"connect by prior" is clause which is used in hierarchical queries.Example
select ename,empno,mgr,job
from emp
start with job='PRESIDENT'
connect by prior empno=mgr;
"connect by prior" is clause which is used in hierarchical queries.Example
select ename,empno,mgr,job
from emp
start with job='PRESIDENT'
connect by prior empno=mgr;
| Previous Question | Next Question |
| Explain ROWID? | Explain What is meant by Scrollable cursor? |