Changes in This Release

This preface contains:

• Changes in Oracle Application Express Release 18.2
  
• Changes in Oracle Application Express Release 18.1
  

Changes in Oracle Application Express Release 18.2

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

• New Features
  
• Deprecated and Desupported Features
  
• Other Changes
  

New Features

The following features are new in this release:

• Sample Datasets

  Pre-Populate Create App Wizard with JSON for Sample Datasets - After installing a sample dataset, clicking Create Application launches the Create Application Wizard and pre-populates it with components built on the sample dataset.

  See "Using Sample Datasets"

• ORDS based RESTful Services

  Allow users to include/exclude Enable Schema and Privileges from ORDS Service export - If you are running ORDS 18.3 or later , diplays the Include Enable Schema and Include Privilages fields.

  • Include Enable Schema - (Default: Enabled) -This dictates whether the resulting export script contains ORDS.ENABLE_SCHEMA statement

  • Include Privileges - (Default: Enabled) -This dictates whether the resulting export script contains the privilege definitions associated with the chosen module(s). (includes protected module, roles, and resource patterns)

  See "About ORDS RESTful Services Dashboard"

• Installing a Sample RESTful Service Module with Schema ORDS Enabled

  Warn User when Resetting Example service if you have added Templates manually - Clicking Reset Sample Service button resets the sample service. Reset Sample Service Verification dialog appears warning the user that the service will be completely deleted and re-created.

  "Managing RESTful Service Modules"

• Registering Schema with ORDS

  Extend Functionality of ORDS Schema Attributes dialog - ORDS enabling a schema that is assigned to more than one workspace as the default schema causes issues with workspace related static files. Oracle recommends that you do not ORDS enable schemas shared amongst multiple workpaces until you are running ORDS 18.3 or higher.

  "Registering Schema with ORDS"

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.

Changes in Oracle Application Express Release 18.1

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

• New Features
  
• Deprecated and Desupported Features
  
• Other Changes
  

New Features

The following features are new in this release:

• Quick SQL

  Quick SQL is used to rapidly design and prototype data models using a markdown-like shorthand syntax. It is simply a quick way to develop a script for simple tables and views. Once the SQL is generated it can be tweaked and expanded upon. Quick SQL provides a quick way to generate the SQL required to create a relational data model from an indented text document.

  See "Using Quick SQL"

• Sample Datasets

  Sample datasets enable you to easily build sample applications. Each dataset includes sufficient data to build pages with various different components. Install, refresh, or replace sample datasets within one of the schemas associated with your workspace. The database objects can also be easily removed. Each dataset includes various database objects and sample data. The sample data is available in one or more languages.

  See "Using Sample Datasets"

• New REST Workshop

  Introduction to the concepts of RESTful services and describes how to create, edit and delete RESTful Services using Application Express.

  RESTful Services enable the creation of a set of standards-based API’s on top of database objects available for a workspace. Without connecting directly to the underlying data source these API’s allow external systems to interact securely with the data by querying, inserting, updating or deleting.

  See "Enabling Data Exchange with RESTful Services"

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.