Result Set Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Result Set
  4. Use minus and intersect
(select table_name
 from all_Tables
 where owner = 'STUDENT1'
 minus
 select table_name
 from all_Tables
 where owner = 'STUDENT2')
INTERSECT
select table_name
from all_Tables
where owner = 'STUDENT3'
/