Re: insert values from a ROW object

for a in select * from temp_rslt

loop

   insert into final_rslt select row(a.*);

end loop;

I want to do something like the above. I don't want to have to name each 'a.' variable.

Is it possible?

TIA

Mike