Variable as column name in SELECT statment

[IjumpOverU]

Is there any way to use a variable as a column name in a select statement?

Example:

DECLARE
v_col_name VARCHAR2(40);
v_value VARCHAR2(80);

SELECT v_col_name INTO v_value
FROM table_name;

This is of course a valid sql statement, but I do not want the column name selected into the value variable I want the column name varibale to be referenced as the column in the "table_name" table.

 

[BJCooperIT]

Try a search on dynamic SQL (you have to build the SELECT statement as a text string and then execute it).

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus