Manage Oracle Application Express Websheet Applications

Websheet applications are created from the Oracle Application Express Application Builder. Websheets are applications designed to be created and modified by business users, with no knowledge of SQL necessary. A Websheet is like a wiki, except that Websheets can be driven by data included in the application.

These applications are highly dynamic and defined by their users. Websheet applications include navigation controls, search capabilities, and the ability to add annotations such as files, notes, and tags. Websheet applications can be secured using access control lists and several built-in authentication models.

Topics:

• Create Websheet Database Objects

• Create a Websheet Application

• Modify a Websheet Application

• Remove a Websheet Application

Create Websheet Database Objects

Before creating a Websheet application, required database objects must be created. This section describes how to create the required objects.

To create required Websheet database objects:

1. Access Oracle Application Express Application Builder from the Oracle Database Exadata Express Cloud Service console. See Access Oracle Application Express.

   The Application Builder home page displays.

2. Click Administration icon at top right.

   The Administration menu displays.

3. Click Administration.

   The Administration home page appears.

4. Under Tasks on the right panel, click Websheet Database Objects.

   The Websheet Database Objects page appears.

5. Click Create Websheet Database Objects.

   The required schemas and objects display.

6. Follow on-screen instructions.

To learn more, see Removing and Validating Websheet Database Objects in Oracle Application Express Administration Guide .

Create a Websheet Application

Before creating a Websheet, required Websheet database objects must exist.

To create a Websheet application:

1. Access Oracle Application Express Application Builder from the Oracle Database Exadata Express Cloud Service console. See Access Oracle Application Express.

   The Application Builder home page displays.

2. Click Create.

   This first page of the Create Application wizard displays.

3. Select Websheet.

   The Create Websheet page appears.

4. Click Create Websheet.

   The Websheet Created page appears.

5. To test the Websheet, click Run Websheet.

To learn more about creating Websheet applications, see Create Websheet Database Objects.

To learn more about creating and modifying Websheet applications, see Creating a Websheet Application in Oracle Application Express Application Builder User's Guide .

To learn about using Websheet applications, see Using Websheets in Oracle Application Express End User Guide .

Modify a Websheet Application

You can use Oracle Application Express to modify an existing Websheet application.

To modify a Websheet application:

1. Access Oracle Application Express Application Builder from the Oracle Database Exadata Express Cloud Service console. See Access Oracle Application Express.

   The Application Builder home page displays.

2. Click the websheet you want to modify.

   The Websheet Properties page appears.

3. Make modifications.

To learn more about creating and modifying Websheet applications, see Creating a Websheet Application in Oracle Application Express Application Builder User's Guide .

To learn about using Websheet applications, see Using Websheets in Oracle Application Express End User Guide .

Remove a Websheet Application

Use Oracle Application Express to remove Websheet applications from your Oracle Database Exadata Express Cloud Service.

To remove a Websheet application:

1. Access Oracle Application Express Application Builder from the Exadata Express console. See Access Oracle Application Express.

   The Application Builder home page displays.

2. Click the websheet you want to remove.

   The Websheet Properties page appears.

3. Click Delete.

   The Confirm Delete page appears.

4. Click Permanently Delete Now.

To learn more about deleting Websheet applications, see Deleting a Websheet Application in Oracle Application Express Application Builder User's Guide .

To learn about using Websheet applications, see Using Websheets in Oracle Application Express End User Guide .