Rapid Application Development and data management using Oracle APEX and SQL
Author:
- 25 January 2024
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 000297-000302
Abstract
SQL language forms a common way to access data in the database. It can be effectively used for creating data-driven applications, as well. Low-code programming has become popular in the non-IT sphere to allow users to create applications quickly, efficiently, and easily. This paper deals with the data-driven applications created in the Oracle APEX technology, covered by the Erasmus+ project BeeAPEX, run on the Oracle Cloud infrastructure. Besides, it deals with the data layer. Oracle Database 23c brought many syntactical enhancements. One of them is just the possibility to join the data in Update and Delete operations. In this paper, that concept is specified and discussed, followed by the performance evaluation of the newly introduced solutions compared to the SQL ANSI standard.Keywords
This publication has 8 references indexed in Scilit:
- Modern Oracle Database Programming2023
- Towards Optimal Tradeoff Between Data Freshness and Update Cost in Information-update Systems2022
- The Complexity of the Data Retrieval Process Using the Proposed Index ExtensionIEEE Access, 2022
- Extending Oracle Application Express with Oracle Cloud Features2022
- Expert Oracle Database Architecture2022
- Understanding Oracle APEX 20 Application Development2020
- Practical Oracle SQL2020
- Some innovations of teaching the course on Data structures and algorithms2019