You should consider supplying the columns as part of the query and not using
*. If you did, basically you can change the order without changing the
order of the table. The order in the table, if done properly actually has
performance implications if changed.
--
Robert Fazio, Oracle DBA
rfazio_at_home.com
remove nospam from reply address
http://24.8.218.197/
"JD" <mail_at_mail.com> wrote in message
news:IEWZ4.162148$VR.2640661_at_news5.giganews.com...
> I am using 7.3.4 and would like to be able to change the order of the
colums
> (there are about 25) in a table. A front-end program I use queries the
> database and displays the columns in the same order as they are in the
> schema manager. I can change the order of the columns after I run the
query,
> but it would be nice to re-arrange them so that I could put the more
usefule
> information towards the top. Thanks for any help.
>
>
Received on Sun Jun 04 2000 - 00:00:00 CDT
