Skip to Main Content

SQL & PL/SQL

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 on Apr 20 2018
Added on Mar 23 2018
6 comments
121 views