LOB data types won’t allow you ORDER BY or GROUP BY be applied over it

You can’t have LOB  data types (CLOB, BLOB, BFILE) ordered. Oracle will trigger an error when you try to order on LOB fields

Same with grouping. You can’t apply GROUP BY on LOB fields. It will raise the same error.


Leave a comment

Your email address will not be published. Required fields are marked *