Creating a cursor to select from a field - which field is determined by variable.

[courbiff]

Hi everybody

I'm wrinting a stored procedure in order to use this last one in a migration script.

During the writing i've notice that i have to use a variable in a cursor ..

For example

I fetch the variable var_name which give the result of one request in this i have for example ashley, kate etc ..

I wanna use ashlet, kate .. in order to selecte the specifies fields in another table

So i want to make SELECT ashley,kate FROM table; in orde rto see what is stocked in the column ashley and in the column kate but instead of having the informations of theses columns when i make SELECT var_name FROM table i've ashley, kate like i've write SELECT 'ashley', 'kate' FROM table or 1 if i write SELECT 1 FROM table

The string stocked in the variable isn't interpreted as a column names

>So it's possible tu use a variable to select fields ???

> Thanks for your help

[amitpatel66]

Hi everybody

I'm wrinting a stored procedure in order to use this last one in a migration script.

During the writing i've notice that i have to use a variable in a cursor ..

For example

I fetch the variable var_name which give the result of one request in this i have for example ashley, kate etc ..

I wanna use ashlet, kate .. in order to selecte the specifies fields in another table

So i want to make SELECT ashley,kate FROM table; in orde rto see what is stocked in the column ashley and in the column kate but instead of having the informations of theses columns when i make SELECT var_name FROM table i've ashley, kate like i've write SELECT 'ashley', 'kate' FROM table or 1 if i write SELECT 1 FROM table

The string stocked in the variable isn't interpreted as a column names

>So it's possible tu use a variable to select fields ???

> Thanks for your help

Check out the logic for executing dynamic SELECT statement using PLSQL 9i:

declare
ab varchar2(20) := 'item'; -- This variable stores column name of table a
b varchar2(20);
str varchar2(100);
begin
str:= 'SELECT '||ab||' from a where item ='||CHR(39)||'apple'||CHR(39);
EXECUTE IMMEDIATE str;
end; 
 

Try applying the same logic to your requirement....to make use of variable as column names

[pbmods]

Heya, Cour. Welcome to TSDN!

Changed thread title to better describe the problem (did you know that threads whose titles do not follow the Posting Guidelines actually get FEWER responses?).

Try using a prepared statement.