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;