文档地址:http://docs.oracle.com/cd/B19306_01/server.102/b14200/queries007.htm#sthref3193
SELECT
,UPDATE
, or DELETE
statement in which thesubquery is nested. A correlated subquery is evaluated once foreach row processed by the parent statement. Oracle resolvesunqualified columns in the subquery by looking in the tables namedin the subquery and then in the tables named in the parentstatement.