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!

How to load data from different table but save it to another table?

T101_cyberdyneSep 7 2013 — edited Sep 20 2013

Hi all,

i've been using apex and i understand how it updates and saves records normally.

For this case, i would need to load from a table but save it to another table upon submit button.

I'm aware that it would be easy like forms where i could do a manual insert process. im doing it in tabular forms and i dont really know how to manipulate this process.

suppose that i'm loading a set of questionnaires on the tabular form and have a yes/no selection.

so the questions would come from table A and i would need to save it to table B.

in this case i cant just set default value for the each row of tabular for the questions coz it would be dynamic and this example is on a small scale. i would need it to load from table A and save to table B.

could anyone guide me on doing this or provide any tutorials of some sort?

This post has been answered by Epic Fail on Sep 10 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 18 2013
Added on Sep 7 2013
4 comments
564 views