Oracle glossary: Subquery
Oracle subquery is a sql query within another sql query.
Some example:
select tab.name, tab.surname from
(select name, surname from customer where surname like ‘S%’) tab
select id from myusers where (name, surname) in
(select name, surname from customer where surname like ‘S%’) tab
select (select ‘1’ from dual) from table.