differences

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