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.
You may also like
It is normal if some or all grouping attributes will not be present in SELECT statement. The grouping will work anyway. SELECT […]
When we are using a format mask ( for example with TO_NUMBER function ) we have basically three options : 1 We […]
A non-equijoin is represented by the use of an operator other than equality operator. A non-equijoin is used when no corresponding columns […]
An inline view is a SELECT statement in the FROM-clause of another SELECT statement. In the query below the INLINE VIEW is : (SELECT AVG(salary) […]