Changing column order

From: Thor Morten Kopaas <thor_at_geodata.no>
Date: Tue, 23 Mar 1999 10:39:48 +0100
Message-ID: <GjJJ2.57$Yk.254@news1.online.no>

Hei,

After a table has been created, is there a way to change the order in which the columns are
displayed when doing for eksample

select * from employee
or
desc employee

Lets say that when the table was created, 'desc employee' gives :

Column Name                    Null?            Type


------------------------------     --------             ----


NAME                                                     VARCHAR2(30)
SALARY                                                 NUMBER(9)
EMPNO                            NOT NULL   NUMBER(9)

but I would like it to be :

Column Name                    Null?            Type


------------------------------     --------             ----


EMPNO                            NOT NULL   NUMBER(9)
NAME                                                     VARCHAR2(30)
SALARY                                                 NUMBER(9)

Thanks,

Thor Received on Tue Mar 23 1999 - 03:39:48 CST