"harry" <a_at_abc.com> wrote in message
news:_Szpf.11612$iz3.6519_at_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
> >
>
>
You can also just ask for the columns in whatever order you want. The
actual order in the table is irrelevant.
Jim
Received on Mon Dec 19 2005 - 09:43:28 CST
