Re: column name order & insert into tab select

In article <952106021.21825.2.pluto.d4ee154e_at_news.demon.nl>,   "Sybrand Bakker" <postbus_at_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. Received on Fri Mar 03 2000 - 00:00:00 CST