67%(12)8 out of 12 people found this document helpful
This preview shows page 272 - 277 out of 546 pages.
The inner query is executed first, producing a query result. The main query block is then processed and uses the values that were returned by the inner query to complete its search condition. In fact, the main query appears to the Oracle server as follows:SELECT last_name, salary, department_idFROM employeesWHERE salary IN (2500, 4200, 4400, 6000, 7000, 8300, 8600, 17000);