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

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