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.
精彩评论