sql - How to group by CLOB data type? -
sql - How to group by CLOB data type? - vendor upgrade changed column_a varchar2 clob. query contains group column_a returns ora-00932 "inconsistent datatypes: expected - got clob . when exclude group column_a in query, don't error don't results want. thus, need grouping clause. is there way grouping clob info type? sql oracle oracle11g group-by