Re: select with column name stored in variable

> SELECT map_col INTO mc FROM meta_tab WHERE ...
> SELECT mc INTO col_val FROM real_tab WHERE ...
> ...

Maybe try dynamic SQL:

SELECT map_col INTO mc FROM meta_tab WHERE ... EXECUTE IMMEDIATE 'SELECT ' || mc || ' INTO col_val FROM real_tab WHERE ...'

adam Received on Thu Jan 02 2003 - 05:44:29 CST