Have a look at using the 'intersect' and 'minus' functions within Oracle SQL. Very easy to use and produce all the results you require without messing about with all of the horribly complicated and easy to get wrong content comparison SQL that's been proposed. Which, btw, will all fail where there are null values (null != null).

rdfield