Changes in This Release

This preface contains:

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

The following feature is 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.