Xref: alice comp.databases.oracle.misc:35514
Path: alice!news-feed.fnsi.net!netnews.com!newsfeed.wirehub.nl!news.wirehub.nl!not-for-mail
From: "robie" <rlaarhoven@sql-integrator.nl>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Referencing columns by their position in a table ??
Date: Wed, 7 Jul 1999 14:52:07 +0200
Organization: Wirehub! Internet
Lines: 27
Message-ID: <7lvj5i$d5m$1@thor.wirehub.nl>
References: <931349966.7333.0.nnrp-12.d4e48d0d@news.demon.co.uk>
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3

That is easy,

take a look at dba_tab_columns.

select column_name
from dba_tab_columns
where column_id =2
and table_name =  'TABNAME'

Rob

Matt Randle heeft geschreven in bericht
<931349966.7333.0.nnrp-12.d4e48d0d@news.demon.co.uk>...
>Can anyone tell me if there's a way of specifying a column to retrieve as
>part of a select statement by the position of the column in the table.
>
>For example, a have a table where I know I want to retrieve the 2nd column
>but I do not know what the column is called ??
>
>Thanks,
>
>Matt.
>
>
>