SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Insert agreegate into table

1030695Aug 3 2016 — edited Aug 5 2016

Hi All,

Could you please help me out with this.

I've create table, to which the user enters values. However i would need to sum of each column based on primary key.

1 10 12 14 19 20

1 12 15 15 15 15

1 13 17 17 18 20

Here are the values, i would need to sum all the column values and insert into another table based on column1.

OUTPUT

1 48 61 63 70 75

help me do this using a procedure.

Apex doesnt support aggregate column insertion. Appreciate insight on the same.

Thanks,

Siv

This post has been answered by Chris Hunt on Aug 3 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2016

Added on Aug 3 2016

#apex, #plsql, #sql

6 comments

469 views