I am working on Oracle 220.127.116.11. I have created a table EMP_A with 30 columns and created copy of same structure with an additional column STATUS VARCHAR2(3) data type and table_name is EMP_Mtch_UNMTCH.
My requirement here is,
Table EMP_A , every day once it will get refresh. Now I would like to write a procedure which is going to compare prior day data and current day data ( daily) and load the data into EMP_Mtch_UNMTCH table with status( YES --> Data Matched, NO--> not macthed) and then I want to capture only STATUS = 'NOT MACTHED' data export to .csv .
Can anyone please advise me on it.