need a procedure to make minus query as output for 2 tables
977256Nov 30 2012 — edited Nov 30 2012Can anybody help me to create a procedure so that I could get minus query of 2 table as a result.
Requirement:
I have two table 1- src_table_list ,2- tgt_table_list both tables have 2 columns : serial_no,table_name and 100 records each. and details mentioned in column "table_name" are actually tables name which present in my testing database.
so I need one procedure which will pick one table_name from src_table_list and one table_name from tgt_table_name each time recursively and provide minus query as a result. as below.
select c1,c2,c3,c4 from table1 --(fetched from src_table_list)
minus
select b1,b2,b3,b4 from table2 --(fetched from tgt_table_list)
Can any body give or help me to create the procedure..as I have to prepare minus query for more than 200 tables and then I need to test them for integration testing..
Edited by: 974253 on Nov 30, 2012 5:39 AM