SQL Plus Question:
Download Questions PDF

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;

Download SQL Plus Interview Questions And Answers PDF

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