Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Referencing columns by their position in a table ??
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