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

Home -> Community -> Usenet -> c.d.o.server -> Re: Reorder columns?

Re: Reorder columns?

From: harry <a_at_abc.com>
Date: Mon, 19 Dec 2005 14:56:58 GMT
Message-ID: <_Szpf.11612$iz3.6519@text.news.blueyonder.co.uk>


thanks for the replies, think I'll just leave it as it is, doesn't cause a problem, just would have been neater that's all!

<sybrandb_at_yahoo.com> wrote in message
news:1135003961.834319.140660_at_g14g2000cwa.googlegroups.com...
> There is not.
> Usually RDBMSes are being *designed* instead of hacked together, and
> adding a column occurs seldomly.
> You could of course also
> -create a view on this table with the correct column order
> -dump this (and possibly other ) table and start all over again, and
> now do things *properly*
>
> The last option is probably the best in your case.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
Received on Mon Dec 19 2005 - 08:56:58 CST

Original text of this message

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