sql - How to retrieve column name and its value from cursor -


is there way each column name , column value of each row using cursor. below, have cursor c loop through each row of table t

 c in (select * t)    loop      --something dbms_output.put_line(c.columname : c.columnvalue);   end loop 

p/s:sorry bad english. english not native language

you need use dbms_sql package instead of simple loop cursor. it's quite complex, luckily tom kyte has done work here


Comments

Popular posts from this blog

java - Oracle EBS .ClassNotFoundException: oracle.apps.fnd.formsClient.FormsLauncher.class ERROR -

c# - how to use buttonedit in devexpress gridcontrol -

nvd3.js - angularjs-nvd3-directives setting color in legend as well as in chart elements -