Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Query Select

 

Writing Multiple Row Subqueries

A multiple row subquery returns one or more rows to the outer SQL statement. The outer query may use the IN, ANY, or ALL operator to handle a subquery that returns multiple rows.