Explain Connect By Prior?

1.	Explain Connect By Prior?
Answer» RETRIEVES ROWS in hierarchical ORDER eg. select empno, ename from emp where. Retrieves rows in hierarchical order eg. select empno, ename from emp where.

Answer»

RETRIEVES ROWS in hierarchical ORDER eg.
select empno, ename from emp where.

Retrieves rows in hierarchical order eg.
select empno, ename from emp where.

Discussion