Oracle APEX offers all the tools you need to be productive, deliver on time, and produce stunning results for your business.
The development environment of APEX can now be rendered with a darker color scheme, which reduces eye strain and is especially helpful for those who are developing late into the night.
Form Region Enhancements
Form pages, used to manage CRUD operations on a single record, have been significantly enhanced, including a new region type specifically for form regions, and the ability to utilize REST Enabled SQL and Web Source within form regions.
Forms Region Type
In prior releases, developers would utilize a Static Content region and place items associated with a Pre-Rendering process. This has changed markedly with the introduction of the Form region type and significant changes in how data is retrieved and processed for these regions. One of the big advantages of this enhancements is that you can now update multiple tables within a single form page.
Changed Source Definition
Instead of defining the source in the Pre-Rendering process, developers now define the source within the region definition.
Expanded Source Type
The source for a Forms Region now includes Table, SQL based, or PL/SQL Function returning SQL Query
Additional Region Attributes
Form regions attributes include edit properties, similar to Interactive Grid properties, including enabling / disabling editing, allowed operations, allowed operation column, lost update type, and edit authorizations.
Modified DML Process
The DML process used to insert, update, or delete a record has been modified to be based on a Form region, rather than being based on a table.
Updated Item References
Rather than specifying the source type as Database Column and the associated table column, developers can now specify the Form region, data type and Database column.
REST Enabled Forms
The built-in support for REST Enabled SQL and Web Sources has been extended to Form regions, allowing read and write access to remote data sources.
REST Enabled SQL
Developers who have REST enabled a table or view can declaratively create full CRUD form pages, as simply as creating a form page on a local database table.
When a REST API is defined as a Web Source Module the automatic discovery now identifies available operations, including PUT, POST, and DELETE. Based on the available operations, corresponding CRUD operations will be defined on form pages based on these Web Sources.
REST Enabling Database Objects
Within SQL Workshop > Object Browser developers can now declaratively REST enable tables or views.
The data upload functionality in SQL Workshop and Create Application From a File have been modernized with a new drag & drop user interface and support for native Excel, CSV, XML and JSON documents. A new public data loading PL/SQL API is also available.
Streamlined User Interface
Simply drag and drop the file you want to load, then follow a simple wizard to load your data.
Enhanced Create App From a File Wizard
Create apps based on the table created when uploading data. The app will include report and form pages, and a dashboard page, based on the new table.
Support for CSV, XSLX, XML and JSON files
Load data from various popular data file types.
Upload large files in the background
Large files are automatically processed in the background.
File settings, data types, format masks, and column sizing are automatically detected.
Introduction of the APEX_DATA_PARSER API
This new API provides a developer friendly interface to parse files and exposes more advanced functionality.
Improved Charts and Library Upgrades
The version of Oracle JET incorporated into APEX has been upgraded to Oracle JET 6.1. There are also a number of other improvements.
New Chart Type - Status Meter Gauge
The Status Meter Gauge can be circular, horizontal, or vertical, and replaces the Dial Gauges.
Declarative Font Formatting
Additional declarative attributes allow developers to easily change the style used to render axes, legends, and values.
Define labels for groups and categories for stacked charts.
Gantt charts now include declarative tooltip support.
The included libraries have been upgraded to jQuery 3.3.1, and jQuery UI 1.12.1.
Universal Theme has been refreshed with UI refinements, accessibility improvements, new template options and deeper control via Theme Roller to help your applications look better than ever.
There are a number of accessibility improvements including a new "Skip to Main Content" link.
New Navigation Menu Styles
There are now two additional styles for the tree-based Navigation Menu
Inline Popup Region Template
A new Inline Popup region template is now available.
A number of components and styles have been visually tweaked and refined to provide a more streamlined user interface.
Responsive behavior has been improved for breadcrumbs and other UI components.
Below are a number of additional features you should familiarize yourself with.
Interactive Grid Improvements
A number of new declarative attributes have been added to Interactive Grids such as Select First Row and new Toolbar Controls.
Dynamic Actions Enhancement
New dynamic actions for opening and closing regions have been added.
App Builder Authentication Expansion
Authentication to the App Builder can now be configured to use Social Login.
Other Features and Changes
Save Session State just in memory
APEX Upgrade will automatically copy ACLs
Improved translation editing
Removal of jQuery Mobile
Removal of APEXExportSplitter