Skip to Main Content

Match data in Oracle

AmywilsonSep 7 2022

Hi Experts,
I am working on Oracle 11.2.0.3. 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.
Thanks
Amy

Comments
Post Details
Added on Sep 7 2022
6 comments
112 views