OraFAQ Forum: Forms » How can a variable (which contain the column name) as a column in select clause

Home » Developer & Programmer » Forms » How can a variable (which contain the column name) as a column in select clause (oracle developer, 6i, xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can a variable (which contain the column name) as a column in select clause [message #305094]

Sat, 08 March 2008 07:03

zawar
Messages: 2
Registered: June 2007
Location: Pakistan

Junior Member

hi all,
i want to get the value of dynamic columns from a table where the value of the variable changes dynamically,

to assigning value to variable can i use it in select clause
i.e

declare
temp varchar2(30);
begin
-- assigning value to temp variable
select column_name into temp from user_tab_columns
where table_name = 'EMP' and column_id = 2;
-- using temp variable in select clause
select TEMP into :employee_name from emp;
end;

please help me

Report message to a moderator