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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 07 Jul 1999 22:28:25 +0800
Message-ID: <37836409.6A80@yahoo.com>

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 --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 07 1999 - 09:28:25 CDT