BLOB or CLOB columns Not Allowed in a GROUP BY Expression
You cannot specify BLOB or CLOB columns in a grouping expression, rollup list, cube list, or grouping sets specification.
You cannot specify BLOB or CLOB columns in a grouping expression, rollup list, cube list, or grouping sets specification.