Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select key, glob_value source_table
- minus
- select key, glob_value target_table
- dbms_lob.compare(
- lob_1 IN BLOB,
- lob_2 IN BLOB,
- amount IN INTEGER := 18446744073709551615,
- offset_1 IN INTEGER := 1,
- offset_2 IN INTEGER := 1)
- RETURN INTEGER;
- Select key, glob_value
- From source_table Left Join target_table
- On source_table.key = target_table.key
- Where target_table.glob_value is Null
- Or dbms_lob.compare(source_table.glob_value, target_table.glob_value) <> 0
- select key, to_hash_str_val(glob_value) from source_table
- minus
- select key, to_hash_str_val(glob_value) from target_table
Add Comment
Please, Sign In to add comment