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 ??
Matt Randle wrote:
>
> That doesn't work as you can't use the results of a select statement to
> specify a column name.
>
> For example,
>
> Select (select column_name from dba_tab_columns where column_id = 2 and
> table_name = 'Tabname') from tabname;
>
> is not valid.
>
> Doing it this way would require two sql satements ?? (which actually is
> better than my current method)
>
> Is there anyway of doing it with one statement ??
>
> Matt.
Have a read about dbms_sql under $ORACLE_HOME/rdbms/admin/dbmssql.sql --
"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 07 1999 - 09:28:25 CDT