| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Re: differences
mikharakiri_at_yahoo.com (Mikito Harakiri) wrote in message news:<bdf69bdf.0201290944.45620dd_at_posting.google.com>...
> what is a SQL query that returns all the differences between A and B?
> It is important that position is used for ordering only, so that it is
> pretty much like I'm comparing 2 text files. UNIX diff utility does
> exactly that, but query must be superior, right?-)
Do you expect the results to be the same as the results from UNIX diff? If you just want to know which lines are different, that isn't two bad. But diff actually gives you an output consisting of (a) lines added, (b) lines removed, and (c) lines that are consistent between the two inputs.
 |
 |