SQL shortcut : how to group by 1, 2, 3 ?

(running 8.1.6 standard edition on a Linux Mandrake 7.2)

Hi all,

I'm unable to use the rank of the fields instead of their actual name in my ORDER BY and GROUP BY statements.
It's not a SQLPLUS problem, because I've got the same problem with all my applications.
I guess it should be some point of configuration, but I can't find out. Or would it be something only available in the enterprise edition?

select mdate, count(*) from mtable group by 1

       *
ERROR at line 1:
ORA-00979: not a GROUP BY expression

Thanks for any help,

    Olivier Received on Wed Nov 14 2001 - 12:29:40 CST