Can someone please help on a code which will compare each column in 2 similar structured (similar data as well and one tend to change wherein I need to capture that change) oracle tables and to result in only row numbers, column name (which got updated), old value, new value. Like below. I am quite new to Oracle and so please share the code.
RNUM CNAME OLD_VAL NEW_VAL
------------ -------------------- ------------------------------ -----------------------------
1 ENAME Name11 Name1
1 HIREDATE 13-may-2011 13-may-2001
3 ENAME Name32 Name3
3 HIREDATE 13-jul-2011 13-jul-2001
4 DESIGNATION SENIOR ANALYST ANALYST
5 SALARY 10000 5000