deanlee17
asked on
SQL referencing a column number
Hi Experts,
Is it possible in Oracle SQL to refer to a column by its number rather than the actual name of the column?....
i.e
Select (col1)
From
Where
Thanks,
Dean
Is it possible in Oracle SQL to refer to a column by its number rather than the actual name of the column?....
i.e
Select (col1)
From
Where
Thanks,
Dean
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As AngelIII said already, it is not possible in the select list.
ASKER
Ok thanks guys.
select deptno, deptname
from dept
order by 2, 1 desc