you could sort oracle table with clob column with the following query based on column size :

SELECT column1, column2, clob_column
FROM your_table
ORDER BY DBMS_LOB.GETLENGTH(clob_column) DESC;