Use of variables in "SELECT" Statements ???

Maybe somebody can help us with our problem...

We are two students, trying to create a sqlform30 application (also using SQL, PL/SQL and the other products that come with oracle V.6).

We try to use variables in SELECT Statements like :

SELECT var1 INTO var2 FROM table WHERE ...

var1 should be a variable for a column name, var2 should be just a variable, containing the result of the SELECT statement and table should be a table name.

Our problem is now to get the value of var1.

What happens is, that the "name" and not the "value" of var1 is stored into var2.

Thanks for all your efforts..

Peggy and Peter. Received on Tue Nov 10 1992 - 12:13:22 CET