The other methods will raise an exception if there arecloborblobcolumns. To compare these types you need techniques like hashing the data ordbms_lob.compare. Using JSON “just works”. However you write a full outer join, it has another challenge: handling duplicates. If a row appears twice ...