The GROUP BY clause

Informix^® allows you to use column numbers in the GROUP BY clause

SELECT ord_date, sum(ord_amount) FROM order GROUP BY 1

Oracle does not support column numbers in the GROUP BY clause.

Solution

Use column names instead:

SELECT ord_date, sum(ord_amount) FROM order GROUP BY ord_date