Value of a variable

[sudip]

Hi All,

FOR c2 in (select name from emp) LOOP
FOR i in 1..40 LOOP
vvci := Replace(upper(vvci), ' :INTERMEDIATETABLE.VCOLUMN'||to_char(i), c2.vcolumn||i);
END LOOP;
END LOOP;

In the above code I want to get the value of c2.vcolumn||i. Is there any function which returns the same in PL/SQL.

Thanks and regards
Sudip