--October 29, 2009 Minus Examples
--Oracle uses minus instead of minus

set echo on


--need to have same schema
--with Oracle - not necessarily same names

SELECT * from branch 
minus
select * from branch;

SELECT * from loan 
minus
select * from account;

select * from loan;

select * from branch;

select branch_name from loan
minus
select branch_name from branch;

select branch_name from branch
minus
select branch_name from loan;

select branch_name from branch
minus
(select branch_name from loan
union
select branch_name from account);
union