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»

EG: select EMPNO, ename from emp where.

Retrieves rows in hierarchical order

eg: select empno, ename from emp where.

Discussion