Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Order of columns within a table

Re: Order of columns within a table

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/06/03
Message-ID: <20000603.4483400@p200.nodomain>#1/1

        Have you considered creating a view? If not, the easiest way (which is still ugly) is to rename the table and then CREATE TABLE xxx AS SELECT col1, col2, ... FROM renamed table;

        Then recreate your indexes, constraints, etc.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 6/2/00, 5:36:13 PM, "JD" <mail_at_mail.com> wrote regarding Order of columns within a table:

> 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 Sat Jun 03 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US