ТЕМА:

cursor v_st is blablabla...

...

l_month varchar2(10);

...

for v_counter in 1..3

LOOP

if v_counter := 1 then l_month := 'column_name1' end if;

if v_counter := 2 then l_month := 'column_name2' end if;

....

-- как впихнуть сюда значение l_month вместо имени колонки?????


UPDATE table1 set l_month = v_st.value

WHERE table1.bla_bla_id= v_st.bla_bla_id;

END LOOP;

....

cursor v_st is blablabla...

...

l_month varchar2(10);

...

for v_counter in 1..3

LOOP

UPDATE table1 

   set column_name1 = decode(v_counter,1,v_st.value,column_name1),

        column_name2 = decode(v_counter,2,v_st.value,column_name2)

......



WHERE table1.bla_bla_id= v_st.bla_bla_id;

END LOOP;