Re: Oracle - Column Order

From: <fitzjarrell_at_cox.net>
Date: 17 Oct 2005 15:25:56 -0700
Message-ID: <1129587956.826739.138650@g44g2000cwa.googlegroups.com>

amerar_at_iwc.net wrote:
> Hi,
>
> Is there a way to change the order of the columns in a table? I know
> that you can change the name via using the COL$ dictionary table. Is
> there also a sneaky way like that to change the order of the columns?
>
> Thanks,
>
> Arthur

Most certainly there is, and it's just as idiotic as updating the data dictionary directly, bypassing the provided mechanisms. A question to you: why do you feel compellled to alter the column order in a table? Is it for 'convenience' so a 'select *' puts data into YOUR desired order without effort? If so I suggest you cease your lazy attitude and actually write usable queries absent the 'select *' shorthand as such has absolutely NO place in production code.

Updating COL$ is foolishness run amok. Stop doing such things, lest you send your database into oblivion with no hope of resurrection as Oracle Support will disown you.

David Fitzjarrell Received on Mon Oct 17 2005 - 17:25:56 CDT