SQL Plus Question:
Download Job Interview Questions and Answers 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;
"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 Question | Next Question |
| Explain ROWID? | Explain What is meant by Scrollable cursor? |