What Is a Subquery in Oracle?
Submitted by: AdministratorA subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The output of the subquery will be used in the final evaluation of the criteria. Usually, subqueries are used in the following Boolean operations:
* "expression IN (subquery)"
* "expression NOT IN (subquery)"
* "EXISTS (subquery)"
* "NOT EXISTS (subquery)"
Submitted by: Administrator
* "expression IN (subquery)"
* "expression NOT IN (subquery)"
* "EXISTS (subquery)"
* "NOT EXISTS (subquery)"
Submitted by: Administrator
Read Online Oracle Database Job Interview Questions And Answers
Top Oracle Database Questions
| ☺ | Where Are the Settings Stored for Each Instance in Oracle? |
| ☺ | What Happens to Indexes If You Drop a Table? |
| ☺ | What Is Input Buffer in SQL*Plus? |
| ☺ | What Is Oracle Open Database Communication (ODBC)? |
| ☺ | How To Use Values from Other Tables in UPDATE Statements using Oracle? |
Top DB Oracle Categories
| ☺ | Oracle PL-SQL Interview Questions. |
| ☺ | Oracle DBA Interview Questions. |
| ☺ | Oracle D2K Interview Questions. |
| ☺ | OCI Interview Questions. |
| ☺ | Forms Reports Interview Questions. |
