Thank you friend I will look into this and get back to you if required .
Thanks once again for the detailed info.
vijaya hyd
Last Activity: May 6 '13, 05:56 AM
Joined: May 2 '13
Location:
-
It is oracle 11g R2.
I feel happy if you can provide a sample as I am a newbie to oracle pl/sql
Thanks in advanceLeave a comment:
-
Thank you very much for the quick response. As you have mentioned , #2 and #3 I have done using joins and I will try #1 with your suggestion and if possible can you provide a sample.Leave a comment:
-
Sincere apologies for not giving you clear picture of what I have done.
Right now I am taking the inner join of the two tables and looping each column and checking each column value in both the tables and comparing the values, which is taking lot of time.
...Code:loop for rows starts loop for columns starts ... val1=select '||col1' from tableA where key_value='||_ID||' val2=select '||col1' from tableB where
Leave a comment:
-
I could able to save excels into two tables.
I need to compare col1 of TableA to col1 of TableB, similarly 30+ columns I have to compare and if any change found, I need to Insert those changes in TableC
TableC structre is like
ID ColumnName TableA_Value TableB_Value
1 Emp_Dept Accounts Admin
1 Address XYZ ABC
2 Sal 10000 12000Leave a comment:
-
I did not get your quextion.
Let me know what things need to make it more clear to you to understand the problem. should I give sample data, which is of 50+ columns and above 300,000 records...Leave a comment:
-
Excel/CSV data to Oracle Tables and compare data
I have two excel files(say XL1, XL2) with same structure.
1) Part of XL1 data may exist in XL2 with few column values changed(modifie d field values)
2) Few records of XL1 may be delted in XL2(deleted)
3) New records may be added in XL2(newly added)
Task
-----
I need to load two excel into two different tables in the same (Oracle) database and compare the same and need to give output as
...
No activity results to display
Leave a comment: