Re: insert values from a ROW object

Thomas, Yes, in my example the loop is not necessary, but in my real application it is. :-) Thanks.

On Thu, Sep 22, 2016 at 2:55 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Thu, Sep 22, 2016 at 2:42 PM, Michael Moore <michaeljmoore@gmail.com> wrote:

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?

INSERT INTO final_rslt VALUES ( (a).* );

David J.