SQL Plus Question:
Download Questions PDF

Please Explain Connect by Prior?


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;

Download SQL Plus Interview Questions And Answers PDF

Previous QuestionNext Question
Explain ROWID?Explain What is meant by Scrollable cursor?