5 Learn About Oracle Application Express

After you create an APEX service and create a workspace and workspace administrator account, you can start exploring Oracle Application Express.

The first time you click Launch APEX, the Administration Services Sign In page appears. Once you sign in, a wizard walks you through creating a workspace and Workspace administrator account as described in Set Up a New APEX Service. In subsequent sessions, clicking Launch APEX displays the Oracle Application Express Sign In page. From here you can continue to set up your workspace and create additional workspaces, user accounts, or configure other administration options.

Understand Oracle APEX Administration

Access Oracle Application Express Administration Services (Administration Services) to perform administration tasks such as managing user accounts, creating workspaces, monitoring workspace activity, and viewing log files.

Tip:

To learn more about Oracle Application Express administration, see Oracle Application Express Administration Guide.

About Instances and Workspaces

Creating an APEX Service creates an Oracle Application Express instance which can contain multiple workspaces.

In an Oracle Application Express development environment, users users sign in to a shared work area called a workspace. A workspace enables multiple users to work within the same Oracle Application Express instance while keeping their objects, data and applications private. This flexible architecture enables a single database instance to manage hundreds of applications.

About Application Express User Accounts

You sign in to a workspace using an Application Express user account.

Creating a workspace also creates a workspace administrator account. You can create additional Application Express users in Administration Services. Application Express users are divided into the following roles.

  • End users do not have access to development or administrative capabilities. End cannot sign into a workspace and create applications. End users can only run existing applications.

  • Developers are users who create and edit applications, monitor workspace activity, and view dashboards. Only user accounts with Developer rights can sign into a workspace.

  • Workspace administrators are users who perform administrator tasks specific to a workspace. A workspace administrator account is created for you when you create a workspace. Workspace administrators have both workspace administrator and developer privileges.

  • Instance administrators are users who perform administration tasks over the entire APEX instance, such as workspace creation, monitoring activity and viewing log files. The Instance administrator account ADMIN is created for you when you create an APEX Service instance. Use the ADMIN administrator account to sign into Administration Services.

Create More Workspaces

Create additional workspaces in Administration Services on the Manage Workspaces page.

To create additional workspaces in Administration Services:

  1. Sign in to Administration Services as described in Sign In To Administration Services.
  2. On the Administration Services home page, click Manage Workspaces.
  3. Under Workspace Actions, click Create Workspace.
    The Create Workspace Wizard appears.
  4. On the Create Workspace, specify the following:
    1. Database User - Select the existing database user for the workspace from the list or enter a new username. This user will be of the Workspace administrator. Applications will be created against database objects from this schema.
    2. Password - Enter a password for the database user. A password is required only if you are creating a new user. The password you specify must meet the default password complexity rules. See field-level Help for details on password complexity rules.
    3. Workspace Name - Enter a name for the workspace. A workspace is a shared work area where multiple developers can build applications.
    4. Click Create Workspace.
    Administration Services appears.

See Also:

Managing Existing Workspaces in Oracle Application Express Administration Guide

Create Application Express Accounts

To sign in to your workspace and start building application, you must have an Application Express account with either Developer or Workspace Administrator privileges.

When you create a workspace, a workspace administrator account is created for you. The following task describes how to create additional user accounts in Administration Services.

To create new Application Express account:

  1. Sign in to Administration Services as described in Sign In To Administration Services.
  2. Click Manage Workspaces.
  3. Under Workspace Actions, click Manage Developers and Users.
    The Manage Developers and Users page appears.
  4. Click Create User.
    The Create / Edit User page appears.
  5. Under User Attributes:
    1. Username - Enter the username used to sign in to the system.
    2. Email Address - Enter a valid e-mail address.
      The remaining attributes are optional. To learn more about an attribute, see field-level Help.
  6. Under Account Privileges:
    1. Workspace - Select the workspace in which to create the user.
    2. Default Schema - Select the default schema for this user.
    3. Accessible Schemas (null for all) - Enter a colon-delimited list of schemas for which this developer has permissions when using the SQL Workshop. The list of schemas you enter here restricts the user to a subset of the full set of schemas provisioned for the workspace and determines what schema names the user sees in SQL Workshop.
    4. To specify workspace administrator privileges:
      • User is an administrator- Select Yes.

        Administrator accounts automatically have all developer privileges enabled.

    5. To specify developer privileges:
      • User is an administrator- Select No.

      • User is a developer - Select Yes.

      • App Builder Access - Determines whether a developer has access to App Builder. Use App Builder to create and manage applications and application pages. Select Yes or No.

      • SQL Workshop Access - Determines whether a developer has access to the SQL Workshop. SQL Workshop provides tools that enable you to view and manage database objects. Select Yes or No

      • Team Development Access - Determines whether a user has access to the Team Development. Use Team Development to track and manage issues in a conversational fashion. Select Yes or No.

    6. Account Availability - Select Locked to prevent the account from being used. Select Unlocked to allow the account to be used.

    Tip:

    To create an End User account, for User is an administrator and User is a developer, select No. End users can only run existing applications.
  7. Under Password:
    1. Password - Enter a case-sensitive password.
    2. Confirm Password - Enter the password again.
  8. Click Create User or Create and Create Another.

Tip:

Workspace administrators can also create and edit accounts in Workspace Administration. See Managing Users in a Workspace in Oracle Application Express Administration Guide.

Edit an Existing Application Express Account

Update user attributes, edit account privileges, or change the user account password on the Create/Edit Users page in Administration Services.

To edit an Application Express user account:

  1. Sign in to Administration Services as described in Sign In To Administration Services.
  2. Click Manage Workspaces.
  3. Under Workspace Actions, click Manage Developers and Users.
  4. On Manage Developers and Users page, select a user.
    The Create/Edit User page appears.
  5. Edit the appropriate User Attributes and Account Privileges.
    To learn more about an attribute, see field-level Help.
  6. To reset the account password:
    1. Password - Enter the password.
    2. Confirm Password - Enter the password again.
  7. Click Apply Changes.

Sign In and Explore Your Workspace

Once you have created workspaces and Application Express user accounts, you can sign in to your workspace and start exploring Oracle Application Express.

To sign in and explore your workspace:

  1. Sign in to your workspace as described in Sign In To a Workspace.
    The Workspace home appears.
  2. Explore the Workspace home page.

    The center of the Workspace home page features the following large icons:

    • App Builder - Create an application, composed of a set of HTML pages, based on database objects.

    • SQL Workshop - Access tools for viewing and managing database objects.

    • Team Development - Track and manage issues in a conversational fashion. You can create templates to provide users with starter text for issues and comments. You can apply labels and label groups, assign issue owners, and set milestones.

    • App Gallery - Install and run productivity or sample applications to learn more about the types of applications you can build and how to construct specific types of pages.

    Description of gsadd_workspace_home.png follows
    Description of the illustration gsadd_workspace_home.png
  3. Review the menu bar at the top of the page.

    This menu bar displays on most App Builder pages. Click a menu to access an alternate navigation path to different components within App Builder, SQL Workshop, Team Development, or App Gallery. The illustration that follows shows the App Builder menu.

    Description of gsadd_bldr_home_menus.png follows
    Description of the illustration gsadd_bldr_home_menus.png
To learn more about the controls on the Workspace home page, see "Quick Start" in Oracle Application Express App Builder User’s Guide.

Find Oracle APEX Resources

To learn more about developing applications with Oracle Application Express, see the following resources:
  • Oracle Application Express Release Notes - Contains important information not included in the Oracle Application Express documentation.

  • Oracle Application Express App Builder User’s Guide - Functions as a comprehensive, task-based reference on using the Oracle Application Express development environment to build applications.

  • Oracle Application Express Administration Guide - Describes how to perform administration tasks such as managing workspaces and user accounts as well perform other workspace, application, and instance configuration tasks.

  • Oracle Application Express SQL Workshop Guide - Describes how to use Oracle Application Express SQL Workshop and utilities to load and unload data from an Oracle database, generate DDL, view object reports, and restore dropped database objects.

  • Oracle Application Express End User’s Guide - Explains common Oracle Application Express end user tasks.

  • Oracle Application Express API Reference - Describes the Application Programming Interfaces, referred to as APIs, available when programming in the Oracle Application Express environment.

  • Oracle Application Express JavaScript API Reference - Describes the JavaScript APIs available to Oracle Application Express applications. You can use these functions to provide client-side functionality, such as showing and hiding page elements, or making Ajax (Asynchronous JavaScript and XML) requests.

  • APEX World- Visit an online forum to post a question and collaborate with experts in the area of APEX.

To view all Oracle Application Express publications see Oracle Application Express Release 20.2 books page. To view all resources, see Oracle Application Express Release 20.2.