How to select the most frequent CLOB strings

I have a table with a CLOB column, and I want to select the 100 most frequent occuring CLOB values. I found some SQL that seems to do this sort of selection with other datatypes, but it doesn't appear to work with CLOB, as GROUP BY is causing an ORA-00932: inconsistent datatypes.

Any suggestions?

Thanks,
Dav Received on Mon Dec 30 2002 - 23:38:15 CET