Oracle Application Express (APEX)

Main article: SaaS - History. Philosophy. Drivers of development

Oracle APEX (Application Express) is an application development platform with minimal programming.

2021: Oracle APEX Availability as Managed Cloud Service

On January 21, 2021, it became known that the Oracle APEX platform for developing applications with minimal programming is now available as a managed cloud service. Oracle APEX Application Development is based on the APEX platform. As of January 2021, half a million developers use it as a tool for creating modern mobile and web applications. The APEX platform is available as part of the SUBDOracle Database, and the APEX Application Development platform is a separate service that supports many applications. The service is based on the Oracle Cloud Infrastructure (OCI) and supports more than 500 users, an unlimited number of applications and can be elastically scaled if additional resources are required. The cost of the service is from $360. USA per month. According to a recent Pique Solutions study, Oracle APEX allows you to develop enterprise applications 38 times faster without the need to explore complex technologies.

Oracle APEX

As reported, the APEX Application Development service is suitable for developers who prefer declarative development instead of complex traditional programming. The service is included in the Oracle Cloud Free Tier subscription, which gives the right to use it for free. Applications created and deployed with the APEX Application Development service have the security, scalability, availability, and performance that Oracle Autonomous Database provides.

The APEX service is also pre-configured to work with Oracle REST Data Services (ORDS) and SQL Developer Web. Using ORDS, developers can create REST APIs based on their application data, and using SQL Developer Web, they can compose SQL queries and graphically model data. If you need additional traditional programming capabilities, you can upgrade the service to a fully functional Oracle Autonomous Transaction Processing database with Oracle APEX, which supports traditional Oracle Database client applications running through the API, SQL Net, and also supports Autonomous Data Guard.

The Oracle APEX architecture provides close integration with the database and speeds up communication between the application and the database by a factor of 10. As a result, the response time for end users of applications is reduced.

The APEX Application Development service includes everything you need to create and run applications. There are no additional fees per user, developer, application, or incoming/outgoing data. The APEX service is fully managed. Users do not need to manage the application platform, database, or infrastructure. The cost of the service is from $360. $1 per month for 1 OCPU and 1 TB of data, supporting more than 500 active users with multiple applications.

At the end of 2019, we began using Oracle Autonomous Database with APEX based on the Oracle Cloud Infrastructure cloud infrastructure in the work of our logistics department. The development platform with minimal APEX programming helped our team quickly move from prototype to final product and deploy it within five months. We were able to install a secure and adaptive web-based solution in four distribution centers. As of January 2021, this solution is used around the clock by more than 250 active users who manage a fleet of 600 assets around the clock. told Giovani Cani, Vice President, IT Resources, Wilson Transportation & Leasing Group

2011: Oracle Application Express 4.1

Oracle announced in September 2011 the release of Oracle Application Express Release 4.1, a quick web application tool for Oracle Database. The new version of the Oracle Application Express platform upgrades existing capabilities and offers additional data loading functions, Oracle said.

Oracle Application Express is a free (no-cost) option included in all versions and editions of DBMS Oracle Database 11g. With it, developers can quickly create and deploy professional and scalable web applications for Oracle Database with high performance and protection. To do this, they will only need a standard web browser. Oracle Application Express Release 4.1 can be downloaded from the Oracle Technology Network (OTN) site.

Among the new and upgraded features of Oracle Application Express 4.1 can be noted: data loading - developers can now easily add a user interface to applications that allows you to load data into tables inside the application; Error handling - Exception handling is determined by the developer, which allows you to freely intercept messages generated by Oracle Database databases and make message text accessible and understandable to end users; mobile applications - improved support for mobile platforms, including the ability to visualize forms without HTML tables; Tabular Forms - a new ability to reference the values ​ ​ of table columns using binding syntax for checking and processing data; calendar - enhancements allow developers to include control capabilities in applications through drag and drop operations and generate calendars with editable pages; Dynamic Action - additional support for button management on the client side; Plug-Ins - ordered types of authentication and authorization; Websheets - The appearance and controls of Websheets are substantially redesigned and made intuitive; Availability and Convenience - Improves the HTML code generated by Application Express, as well as existing topics and HTML templates.

The declarative Oracle Application Express development environment can create and maintain applications using wizards and property tables. Information and links are located in the metadata store, which allows you to less often resort to compiling or generating code, noted in Oracle.