开发者

Oracle APEX form based on multiple tables

开发者 https://www.devze.com 2023-01-30 06:37 出处:网络
Can I create a form in APEX which creates/updates records in multiple tables? For e开发者_开发百科xample two tables with a one-to-one relationship.If you are using Automated Row Fetch mechanism, you c

Can I create a form in APEX which creates/updates records in multiple tables? For e开发者_开发百科xample two tables with a one-to-one relationship.


If you are using Automated Row Fetch mechanism, you can use two different ARF for two tables. If you want to have more control, you can define your INSERT/UPDATE statements yourself usign Page Processes.


A simple way would be to create a view that returns the joined tables and base the Apex form on that. You may need to add INSTEAD OF triggers to the view to be able to insert and update successfully.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号