Re: How do you use a variable in the select clause

Hi.

The only way to do this is to use Dynamic SQL (dbms_sql package which is supplied together with Oracle server).

Dennis.

dosberg7268_at_my-dejanews.com wrote:

> 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 Tue Nov 03 1998 - 01:09:02 CET