Logo F2FInterview

SQL Plus Interview Questions

Q   |   QA
‹‹ previous1234

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; 

ROWID is a pseudo column generated at the run time(during inserting value). Its a hexadecimal value which is unique identification for each record 

%IS OPEN,%FOUND,%NOT FOUND,%ROW COUNT 

Database Link is a named path through which a remote database can be accessed 

Correlated subquery is the subquery, where the subquery has been executed for the every row processed by the parent statement. 

‹‹ previous1234

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: