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