From: jeanch@my-deja.com
Subject: Re: column name order & insert into tab select
Date: 2000/03/03
Message-ID: <89p1ch$rtn$1@nnrp1.deja.com>#1/1
References: <89osh9$o13$1@nnrp1.deja.com> <952106021.21825.2.pluto.d4ee154e@news.demon.nl>
X-Http-Proxy: 1.0 x33.deja.com:80 (Squid/1.1.22) for client 192.6.126.68
Organization: Deja.com - Before you buy.
X-Article-Creation-Date: Fri Mar 03 18:47:47 2000 GMT
X-MyDeja-Info: XMYDJUIDjeanch
Newsgroups: comp.databases.oracle.misc
X-Http-User-Agent: Mozilla/4.08 [en] (X11; I; HP-UX B.10.20 9000/778)


In article <952106021.21825.2.pluto.d4ee154e@news.demon.nl>,
  "Sybrand Bakker" <postbus@sybrandb.demon.nl> wrote:
> That was sheer luck.
> Add 'order by column_position' to your select on all_tab_columns.
>
> Hth,
>
As I posted this I starting playing with different things
and discovered that doing
select column_name from all_tab_columns
where table_name = 'tab'
and owner = 'scott'
order by column_id;
works fine;
Many thanks for sparing some time to look into this.

Cheers
JC



Sent via Deja.com http://www.deja.com/
Before you buy.