用于“机场”的 Oracle APEX数据库
我正在创建一个假想机场的数据库，该数据库有一个由 10 个表组成的简化物理模型。最后一部分是为用户制作某种基于网络的 GUI，我将其中分为三种类型：机场经理、航空公司代表和机场网站的用户/访问者。
目前我正计划构建与 Oracle APEX 的接口，我担心它是否适合目标。我需要针对每种类型的用户的多个视图。因此，我需要访客的航班表以及机场经理和航空公司代表的不同控制面板（经理拥有更多权力:)，代表只能更改与他的公司等相关的行的航班信息）。我可以使用 APEX 来实现吗？我可以自己实现 PL/SQL 触发器和过程吗？
我这么问是因为 APEX 安装是一项耗时的任务，我不希望它成为一项浪费时间的任务...
提前致谢。
I'm making a database of an imaginary Airport that has a simplified physical model of 10 tables. The final part is to make some kind of web-based GUI for users, I have three general types of them: airport manager, airline representative and user/visitor of the airport website.
Currently I'm planning to build the interface with Oracle APEX and my concerns are about if it suites the target. I need several views for every type of user. So I need flight table for visitors and different control panels for airport manager and airline representative (manager has more power :), representative can only change flight information on rows related to HIS company etc.). Can I do it with APEX and will I be able to implement PL/SQL triggers and procedures myself?
I'm asking because APEX installation is a time-consuming task and I don't want it to be a time-wasting one...
Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
是的，Apex 可能比任何其他工具更容易构建此类应用程序，并且它具有处理这些要求可能需要的所有灵活性。您可以使用授权方案来为每种类型的用户提供对不同页面以及页面内不同信息和功能的访问权限。
您可能需要先浏览 2 天开发者指南。
Yes, Apex is probably easier than any other tool to build such an application, and it has all the flexibility you could possibly need to handle these requirements. You can use Authorisation Schemes to give each type of user access to different pages, and to different information and functionality within pages.
You may want to start by going through the 2-day developer's guide.