How do you use a variable in the select clause
From: <dosberg7268_at_my-dejanews.com>
Date: Mon, 02 Nov 1998 22:37:51 GMT
Message-ID: <71lc7u$vdv$1_at_nnrp1.dejanews.com>
[Quoted] I'm building a cursor to execute several actions inside of a procedure. But I need to retrieve a value from a dictionary table in order to do a SELECT ..INTO statement. The part I'm having trouble with would look like this: Declare x Varchar2(25); s Varchar2(25); Begin x:='CustId' Select x into s from Orders Where OrderId = 1234; End; As I loop through the cursor I want to constantly be resetting X and insert a value into S. But the Select statement doesn't interpret the value of X as the literal string. I just get the value of X into the variable S.
Date: Mon, 02 Nov 1998 22:37:51 GMT
Message-ID: <71lc7u$vdv$1_at_nnrp1.dejanews.com>
[Quoted] I'm building a cursor to execute several actions inside of a procedure. But I need to retrieve a value from a dictionary table in order to do a SELECT ..INTO statement. The part I'm having trouble with would look like this: Declare x Varchar2(25); s Varchar2(25); Begin x:='CustId' Select x into s from Orders Where OrderId = 1234; End; As I loop through the cursor I want to constantly be resetting X and insert a value into S. But the Select statement doesn't interpret the value of X as the literal string. I just get the value of X into the variable S.
I figure there has got to be some way to do this. I would appreciate any advice.
David Osberg
dosberg_at_yahoo.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Nov 02 1998 - 23:37:51 CET