<p>I have two tables I would like to complare.  One of the columns is type CLOB.  I would like to do something like this:</p>

<pre><code>select key, clob_value source_table
minus
select key, clob_value target_table
</code></pre>

<p>Unfortunately, Oracle can't perform minus operations on clobs.  How can I do this?</p>

Can you access the data via a built in package? If so then perhaps you could write a function that returned a string representation of the data (eg some sort of hash on the data), then you could do
```
```
select key, to_hash_str_val(glob_value) from source_table
minus
select key, to_hash_str_val(glob_value) from target_table
```
```