From: Leyne, S. <Se...@br...> - 2007-07-13 15:33:34
|
Fred, > To clarify a bit more, Oracle 10g allows the following: >=20 > SQL> select 1 a, 2 a, 3 a from dual; >=20 > A A A > ---------- ---------- ---------- > 1 2 3 >=20 > But, it rejects the following: >=20 > SQL> select 1 a, 2 a, 3 a from dual ORDER BY a; What about: select 1 a, 2 b, 3 b from dual ORDER BY a; Sean |