differences

From: Mikito Harakiri <mikharakiri_at_yahoo.com>
Date: 29 Jan 2002 09:44:13 -0800
Message-ID: <bdf69bdf.0201290944.45620dd_at_posting.google.com>



Given

table A (
  position NUMBER,
  textline VARCHAR2
);

table B (
  position NUMBER,
  textline VARCHAR2
);

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?-) Received on Tue Jan 29 2002 - 18:44:13 CET

Original text of this message