Skip to Main Content

APEX

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!

Need to add/update two records on Create/Update button click

Manas MMar 20 2014 — edited Mar 20 2014

I have a table with 5 columns

1. ID - Primary Key

2. Name

3. Address

4. CARB

5. OCAR

Now every time I do an insert into this table to this table I need to add two rows as shown below:

1st row - (Name1,Add1,717,717)

2nd row - (Name1,Add1,,515,515)

The values Name and address are inputs from the screen and CARB & OCAR values are fixed(either 717 or 515). So for every Create button click two records need to be inserted.

Similar when I update any  particular record say Carb- 717 & Ocar-717, I need to also update the other record  Carb-515 & Ocar-515 too. So for every Update button click I need to update two records.

Please tell me as to how do I go about doing this

This post has been answered by vdsadhi on Mar 20 2014
Jump to Answer

Comments

vdsadhi
Answer

Hi

Why don't you use Manual Insert and Update process as per your requirement?.. Give 'Never' for Automatic Processing for DML and try to create a manual process (PL/SQL blocks) and give condition.

Thanks

Lakshmi

Marked as Answer by Manas M · Sep 27 2020
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 17 2014
Added on Mar 20 2014
1 comment
158 views