Data will be first inserted into temp_data(using oracle APEX DML process) after the insertion comlplete i need to get those records and insert into temp_head and temp_detail. In, temp_head i need to insert sum on RATE and sum of Total when ID is same and in temp_detail there will be line wise entry same as temp_data based on ID.
create table temp_head(id number,rate number,total number);
create table temp_detail(id number,rate number,total number);
create table temp_data (id number,rate number,total number);
insert into temp_data(1001,100,100);
insert into temp_data(1001,200,200);
insert into temp_data(1001,300,300);
insert into temp_data(1002,400,400);
insert into temp_data(1002,500,500);
commit;
TEMP_DATA
id rate total
1001 100 100
1001 200 200
1001 300 300
1002 400 400
1002 500 500
So, expected output of TEMP_HEAD for ID = 1001 and ID = 1002:
id rate total
1001 600 600
1002 900 900
TEMP_DETAIL
id rate total
1001 100 100
1001 200 200
1001 300 300
1002 400 400
1002 500 500
is there any way i can accomplish this using trigger.