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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Referencing columns by their position in a table ??

Re: Referencing columns by their position in a table ??

From: robie <rlaarhoven_at_sql-integrator.nl>
Date: Wed, 7 Jul 1999 14:52:07 +0200
Message-ID: <7lvj5i$d5m$1@thor.wirehub.nl>


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_at_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.
>
>
>
Received on Wed Jul 07 1999 - 07:52:07 CDT

Original text of this message

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