The Oracle APEX blog is your source for APEX news, technical tips and strategic direction

  • March 29, 2019

Announcing Oracle APEX 19.1

Joel Kallman
Vice President, Software Development


Oracle Application Express (APEX) 19.1 is now generally available!  APEX enables you to develop, design and deploy beautiful, responsive, data-driven desktop and mobile applications using only a browser. This release of APEX completes the vision of feature-rich applications using any local or remote data source.  APEX 19.1 also introduces a number of exciting new features which dramatically simplify data loading as well as improve the overall development experience.

Some of the improvements in Oracle APEX 19.1 include:

REST-Enabled Forms

The built-in declarative support for REST Enabled SQL and Web Sources has been extended to Form regions, allowing read and write access to remote data sources.  With APEX 19.1, you can now declaratively create report, chart, calendar and form pages on REST Services, all with no code.  This is an important step forward for APEX, as you can now bring the power of SQL to applications which interact with virtually any local or remote data source.

New Form Component

APEX 19.1 introduces a completely rearchitected form component, which not only supports forms on REST Services, but also forms on SQL queries and functions returning SQL queries.  Additionally, all attributes associated with the data source of a form are consolidated on the form region itself, resulting in a much more intuitive development and maintenance experience.

Data Loading

APEX now supports easy data loading into Oracle Database for a variety of file formats, including Comma-separated Values (CSV), JSON, native Excel (XLSX) with multiple sheets, and XML.  Via a simple drag and drop interface, developers can now easily transform their single-user desktop files into beautiful Oracle Database powered web applications.  Additionally, APEX 19.1 introduces the APEX_DATA_PARSER package, which enables developers to easily add the same powerful file upload and data parsing capabilities into their own applications.

Dark Mode

The development environment of APEX 19.1 can now render with a darker color scheme, which reduces eye strain and is especially helpful for developing late into the night. 

Dark Mode in Application Builder

JET Chart enhancements

APEX now includes declarative support for the JET Status Meter Gauge.  Also, new declarative attributes have been added to JET Charts to support the styling of text on a chart, as well as declarative tooltip options for Gantt charts.  The Oracle JET libraries have been updated to JET 6.1.0.

REST Enabled Database Objects

SQL Workshop has been enhanced to now support single-click REST-enablement of database tables, views and procedures.  This will result in the creation of a REST API, provided by the natively integrated Oracle REST Data Services (ORDS).

Interactive Grid enhancements

A number of new declarative attributes have been added to Interactive Grids, including Select First Row, Toolbar Controls, Actions Menu options, and Column options.  With no code, developers now have even greater control with this rich data management component.

JavaScript APIs

With APEX, not only can you create completely no code and low code applications, but you can also create highly customized applications, with control over virtually every aspect of the app. If your requirements go beyond the rich declarative functionality of APEX, there is detailed JavaScript documentation to help you provide customized client-side functionality. Please see the JavaScript API Reference for further information.


As in every APEX release, a number of enhancements and bugs fixes have been made to the productivity and sample applications.  Additionally, numerous bugs have been fixed in APEX 19.1, resulting in even higher quality and stability for APEX environments.

For more information about the new features in APEX 19.1, as well as many of the other exciting enhancements, please see What's New.


Additional Information

Application Express (APEX) is the low code rapid app dev platform which can run in any Oracle Database and is included with every Oracle Database Cloud Service.  APEX, combined with the Oracle Database, provides a fully integrated environment to build, deploy, maintain and monitor data-driven business applications that look great on mobile and desktop devices.  To learn more about Oracle Application Express, visit apex.oracle.com.  To learn more about Oracle Database Cloud, visit cloud.oracle.com/database

Join the discussion

Comments ( 9 )
  • Mohamed Helal Friday, March 29, 2019
    Just in time for an infrastructure overhaul.. Great work. Keep it up please
  • Mustafa Friday, March 29, 2019
    It's great... Thank you Oracle Apex
  • habtom Friday, March 29, 2019
    Thats great news specialy on IG enhancement. Thank you!!!
  • Tony Miller Friday, March 29, 2019
    Thank you Joel and the APEX Development team!!!
  • Kris Scorup Friday, March 29, 2019
    Awesome! Thanks for all the great work APEX dev team!
  • Trevor Watt Saturday, March 30, 2019
    Fantastic. APEX rocks!
  • Reyad Hossain Khan Sunday, March 31, 2019
    Thank you Joel Kallman and the APEX Development team!!!
    Is there any vital change in installation ?
  • Balamurugan Tuesday, April 2, 2019
    Awesome. Thats a true care for developers. Oracle APEX is amazing and making it even better.
  • Oscar E. Duarte O Friday, April 5, 2019
    Always is nice enjoy a new version with mayor features, however DarkMode is fantastic point.
    Thanks Apex Team
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.