Creating an Application Express Database Application from a Spreadsheet

Purpose

In this tutorial, you learn how to create a Database Application in Application Express from a spreadsheet.

Time to Complete

Approximately 15 minutes

Background

Oracle Application Express provides a functionality to create a desktop application based on a spreadsheet data. This can be done by selecting From a spreadsheet in the Create Application Wizard.

What Do You Need?

• Oracle Application Express workspace

• Spreadsheet to create the database application - The tasks.txt spreadsheet is used in this tutorial.

• All files for this hands-on activity are located in the Home/Desktop/APEX_Track/files folder.

• The following files are used in this hands-on activity:

  • tasks.txt

1. In the Application Express login page, enter the following login credentials and click Sign In:

   • Workspace: obe

   • Username: obe

   • Password: oracle

   

2. On the Workspace home page, click the App Builder icon.

   

3. Click the Create button.

   

4. In the Create an Application modal window, select From a spreadsheet.

   

5. For Load Method, select Upload file, comma separated (*.csv) or tab delimited and click Next.

   

6. For Data, click Choose File, navigate to the spreadsheet (or CSV) file, and click Open. Enter \t for Separator, ensure that "First row contains column names." checkbox is enabled, and click Next.

   

7. For Table Properties, select HR for Schema and enter TASKS for Table Name. Review the table properties and click Next.

   

8. For Application Options, accept the default for Application Name and Report Type and click Create Application.

   

9. The application is created successfully.

1. On the Application home page, click the Run Application icon.

   

2. Enter your login credentials and click Log In.

   

3. The home page of the TASKS application, containing the interactive report, is displayed. Click the Edit icon in the first row.

   

4. The modal window to edit the Tasks entry appears. Change the value for Cost and click Apply Changes.

   

5. The Cost has been updated. Now you create a new Task. Click Create.

   

6. Enter details for the new task and click Create.

   

7. The new task is successfully created. You will be able to see the new task in the Interactive Report.

   

• Oracle Application Express Documentation

• Oracle Application Express on Oracle Technology Network

• Oracle Learning Library