如何在oracle中比较单个表的clob列？

How to compare clob columns of single table in oracle?

如何在oracle中比较单个表的clob列?

1 个解决方案

#1

This code should work:

这段代码应该有效:

select * 
    from table 
   where dbms_lob.compare(aClobColumn, bClobColumn) = 0

PS: I haven't tried running it as I am not having access to an Oracle instance at the moment.

PS:我还没有尝试过运行它,因为我目前无法访问Oracle实例。

Reference: https://docs.oracle.com/database/121/ARPLS/d_lob.htm#ARPLS600