Mega Code Archive

 

Categories / Oracle PLSQL / Result Set

 

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