Changes in This Release

This preface contains:

• Changes in Oracle Application Express Release 19.1
  

Changes in Oracle Application Express Release 19.1

The following are changes in Oracle Application Express SQL Workshop Guide for Oracle Application Express release 19.1.

• New Features
  
• Deprecated and Desupported Features
  
• Other Changes
  

New Features

The following features are new in this release:

• Enabling REST Objects from the Object Browser

  Oracle Application Express 19.1 installations that utilize Oracle REST Data Services (ORDS) 17.4 or later support the ability to REST enable database objects using the AutoREST feature of ORDS. You can use AutoREST to REST enable tables, views, packages, procedures, and functions.

  See "Enabling REST Objects from the Object Browser"

• Data Workshop

  A new, improved Data Loading facility is provided with this release.

  • Data Load and Unload wizards to load and unload data to and from the database.
  • Drag and drop delimited files (CSV, tab-delimited), TXT, XLSX files (Excel workbooks), JSON or XML files to load data into a new table.
  • Copy and paste delimited data (CSV, tab-delimited), or select a sample data set to load data into a new table.
  • Data load parser detects almost everything automatically.
  • Create a new table from the loaded data.
  • Data Loading runs in the background - so the dialog can be dismissed if a larger file is being uploaded. If bad rows cannot be inserted into the target table, the whole load is not lost. All failed rows are saved in error table and can be post-processed manually.
  • Unload Data provides 2 options - Text Format, XML Format.

  See "Using Data Workshop"

Deprecated and Desupported Features

See Deprecated Features and Desupported Features in Oracle Application Express Release Notes.

Other Changes

The following are additional changes in the release:

• All content has been updated to reflect new functionality.