Re: Oracle - Column Order

On Mon, 17 Oct 2005 13:46:11 -0700, amerar interested us by writing:

>
> 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?
>

Using sneaky ways to bypass the internal structures is a quick way of violating your support agreement. Hope you are not contemplating this for a production system.

I would consider using "SELECT *" and depending on column order to be very unprofessional, sloppy and lazy for anything other than a demo or prototype environment. Also it will lead to surprises if you ever decide to use Oracle for what it is worth instead of just a big data bucket.

-- 
Hans Forbrich     
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***