oracle 基于多表的Oracle APEX表格
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/4439844/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle APEX form based on multiple tables
提问by Michiel Borkent
Can I create a form in APEX which creates/updates records in multiple tables? For example two tables with a one-to-one relationship.
我可以在 APEX 中创建一个表单来创建/更新多个表中的记录吗？例如具有一对一关系的两个表。
回答by Erkan Haspulat
If you are using Automated Row Fetchmechanism, you can use two different ARF for two tables. If you want to have more control, you can define your INSERT/UPDATEstatements yourself usign Page Processes.
如果您使用的是Automated Row Fetch机制，则可以为两个表使用两个不同的 ARF。如果你想有更多的控制，你可以INSERT/UPDATE自己定义你的语句使用Page Processes。
回答by Tony Andrews
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.
一种简单的方法是创建一个返回连接表的视图，并以此为基础创建 Apex 表单。您可能需要向视图添加 INSTEAD OF 触发器才能成功插入和更新。
