开发者

Oracle APEX form based on multiple tables

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜