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
Post a Comment