use minus and intersect : Intersect « Result Set « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Result Set
  3. Intersect

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'
/








Related examples in the same category

1.INTERSECT: returns the distinct records that exist in both result sets
2.Result set: intersect
3.Intersect a single column
4.intersect with like operator
5.INTERSECT date column