Skip to Main Content

insert values using trigger

Marco FoxxMar 23 2018 — edited Mar 23 2018

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.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Apr 20 2018
Added on Mar 23 2018
6 comments
113 views