1. SQL Workshop Guide
  2. Enabling Data Exchange with RESTful Services
  3. Accessing SQL Developer Web Directly from APEX

7.9 Accessing SQL Developer Web Directly from APEX

Access SQL Developer Web from the SQL Workshop menu.

SQL Developer Web (also known as Database Actions) provides a web-based interface that enables you to execute queries and scripts, create database objects, load data, build data models, and monitor database performance.

Users with Developer rights and access to SQL Workshop can open a SQL Developer Web session for any database schema associated with the current workspace directly from APEX using the SQL Developer Web option on the SQL Workshop menu in the menu bar.

Requirements for enabling the SQL Developer Web menu option include:

  • Oracle REST Data Services release 23.1.0, running in HTTPS mode.
  • An instance administrator must select the Enable SQL Developer Web attribute in Administration Services.

To open a SQL Developer Web session from APEX:

  1. Select the Enable SQL Developer Web attribute in Administration Services:
    1. Sign in to APEX Administration Services.
    2. Click Manage Instance.
    3. Under Instance Settings, click Feature Configuration.
    4. Locate the SQL Workshop section and select Enable SQL Developer Web.
    5. Sign out of Administration Services.
  2. Sign in to your APEX workspace.
  3. Click the SQL Workshop menu.

    Note the SQL Workshop menu now includes a SQL Developer Web menu option.

    Description of sql_developer_web.png follows
    Description of the illustration sql_developer_web.png
  4. Clicking the SQL Developer Web menu results in two behaviors:

    • If there is only one schema associated with the current workspace and that schema already is REST-enabled, a new browser tab with a SQL Developer Web session displays.

    • If there are multiple schemas associated with the current workspace, a dialog displays showing the schemas and indicates if they are REST-enabled.

      Selecting a schema that is not currently REST-enabled, displays the RESTful Services page and prompts you to register the schema as described in Registering Schema with ORDS. Once the schema is registered, a new browser tab with a SQL Developer Web session displays.

    Note:

    Opening a new browser tab with SQL Developer Web invalidates and ends any other open SQL Developer Web sessions for the that browser.

See Also:

Parent topic: Enabling Data Exchange with RESTful Services