any EVAL() equalant functions in SQL or PL/SQL
zam_oraSep 5 2007 — edited Sep 9 2007good day
i have 2 loops ,
outer loop has the real data from a table
and
inner loop has the column name to be selected from outer loop.
so in runtime, i need to select the columns dynamically .thats why i use inner loop. please see below.
for i in data Loop
--
for j in col_name Loop
--column name of data loop should be selected from this col_name loop.
dbms_output.put_line(i.||j.col_name);
End Loop;
--
End Loop;
But this should not work.
is there any eval function in plsql like in java and javascript to resolve this?
please advice.
thanks