Last post Jul 31, 2012 02:52 PM by Muscle_windows
Jul 05, 2012 04:01 PM|Muscle_windows|LINK
I have two oracle tables that I need to compare, find their mismatched data and then insert in into a different table.
Any C# code samples on how to do this?
Jul 05, 2012 04:02 PM|MattsDotNetUsername|LINK
It depends on how the data is mismatched and how you want to fix it. Could you provide an example?
Jul 05, 2012 05:56 PM|rickevry|LINK
You don't need C#. I think the syntax is somethink like:
select * from table1 minus select * from table2
It will return rows that are not the same.
Jul 06, 2012 11:32 AM|Muscle_windows|LINK
In this example, it showed rows with different data's.
Table A is a report from stores while Table B is a report that do our audit. We have thousands of report everyday and manually matching the store reports to the audit reports is time consuming and exhausting.
The program I'm trying to do will enable to find the descrepancies in reports. We use Table B (audit report) to find out if there are any descrepancies in Store Reports.
If descrepancies are found insert the records in Table C .
Jul 06, 2012 11:43 AM|Dr. Acula|LINK
do it in SQL http://www.techonthenet.com/sql/minus.php
Jul 06, 2012 11:57 AM|Muscle_windows|LINK
Tables are in oracle.
Jul 09, 2012 04:06 AM|Dr. Acula|LINK
yes but you must use SQL to retrieve your data?
Jul 26, 2012 03:00 PM|Muscle_windows|LINK
I'm thinking of data reader? I'm not a C# expert that's why I'm not sure what to use. Any suggestions?
Jul 27, 2012 04:23 AM|Dr. Acula|LINK
both myself and rickevry have already given you the solution for this. there is no need for a c# program.
you want to insert the results of a query into a new table, so you need this for the insert
and in your select use minus to find the differences
Jul 31, 2012 02:52 PM|Muscle_windows|LINK
One of my project requirements is to write in .net platform (C# is my choice of language).