Hi,
I need to compare two tables row by row and produce mismatches by column names. i dont want to use dbms comparison utilities. Is there anyway to do in ananmous block? im thinking of two cursors for two tables and compare column by column. In below pseudo code, im using uncl arrays, comma to table utilities in oder to get dynamic column list. but i getting value mismatch error in cursor. another issue im facing is to get column name dynamically. Give me some suggestions to resolve these erros.
declare
variables
cursor c1
select ..dynamic column list..
from tableA;
begin
comma to table( ..dynamic column list..);
for r in (select ..dynamic column list..
from tableB)
-- get one column per row and compare
if c1.column = r.column then
column match
else
column mismatch
-- store and display the mismatched columns
end loop
end