Skip to Main Content

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 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

Ices_Eyes
Up...!
Ices_Eyes
Noone is experiencing the same issue?
-K-
My suggestion is to open a SR at Metalink/MOS (if you have a database support contract), else hope someone from the team is interested in logging/debugging this through the forum.

Regards,
K.
Ices_Eyes
-K- wrote:
My suggestion is to open a SR at Metalink/MOS (if you have a database support contract), else hope someone from the team is interested in logging/debugging this through the forum.

Regards,
K.
Unfortunately I have no a support contract, so...Hoping someone of the developer read this...Maybe it will be fixed in the next release :)

PS: if some developer read this, please let me know, so I stop to try to mantaint this thread alive :P
Ices_Eyes
Any news about this bug? :)
hlaebe
Hi,
did you try GeoRaptor [GeoRaptor |http://sourceforge.net/projects/georaptor/] ? We have tools for indexing, maintaining metadata (which might be the reason for this non-support in SQL Developer, since metadata is required for indexing).

Give it a try, it is free!

Regards,
Holger

Edited by: hlaebe on 03.02.2010 08:56
Ices_Eyes
Thanks, that work! And is pretty useful too... :)
Ices_Eyes
By the way, this bug is still present in version 2.1.1... :-S
1 - 8
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
209 views