Re: select with column name stored in variable

From: Michael Howitz <mhowitz_at_firemail.de>
Date: Thu, 02 Jan 2003 13:11:07 +0100
Message-ID: <3E142C5B.7030705@firemail.de>

rako wrote:

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

thank you. after tying a bit this version worked:

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

(put the INTO-statement to the end).

-- 
mac

real email-adress: mac clondiag com

Received on Thu Jan 02 2003 - 06:11:07 CST