Design a Data Model for an Oracle APEX App on Exadata Express Cloud

Before You Begin

This is the first tutorial in the Building an Oracle Application Express App on Oracle Database Exadata Express Cloud Service series. Perform each of these tutorials sequentially as there is a dependency to complete one before starting the next one.

• Design a Data Model for an Oracle APEX App on Oracle Exadata Express Cloud
• Develop an Oracle APEX App on Oracle Exadata Express Cloud
• Deploy an Oracle APEX App on Oracle Exadata Express Cloud

In this first tutorial, you will design a data model. It takes approximately 15 minutes to complete.

Background

Oracle Application Express is a low code, rapid web application development tool. It enables you to efficiently develop and maintain beautiful, responsive and database-driven applications using only your web browser.

What Do You Need?

• A desktop or laptop computer running Microsoft Windows 7, Apple MacOS 10.9 or later, or Oracle Linux and a web browser. Oracle Application Express supports the current and prior major release of Google Chrome, Mozilla Firefox, Apple Safari, Microsoft Internet Explorer and Microsoft Edge.
• An Oracle Exadata Express Cloud Service account with two service instances. You will develop an app on one instance and deploy it on the second instance of the service.

Install Quick SQL

You will use Quick SQL to design a data model. Quick SQL is a packaged app available with Oracle Application Express. To install Quick SQL, access your Exadata Express Cloud Service instance.

1. On the Oracle Exadata Express Cloud Service instance landing page, click Develop in the left navigation pane.

   

2. On the Develop page, click the App Builder icon. This takes you to the App Builder page that has a number of tools and utilities.

   

3. To see a list of packaged apps, click the Packaged Apps drop-down menu and select Productivity Apps.

   

4. Click the Quick SQL icon.

   

5. In the Install Packaged App dialog, click Next and then click the Install Packaged App button.

   

Design a Data Model

1. Access the Quick SQL app you installed in the previous step. On the App Builder page, click the Quick SQL icon.

   

2. Click the Run button.

   

3. Choose the default set up for Quick SQL. Click the Complete Set Up button.

   

4. In the left pane of the Quick SQL app, start typing shorthand SQL to create the data model. Create the EMPLOYEES table and add a SKILLS table.

   

5. Enter the shorthand SQL displayed below:

 employees /insert 50
      name /nn
      email /lower
      city
      country /values US, US, MX, CA
      skills /insert 150
          skill /nn /upper /values Java, Java, Java, JS, JS, SQL, PHP, Perl, ABCS, APEX, Python
         proficiency num /nn /check 1, 2, 3, 4

6. Create a view. Enter the shorthand SQL statement displayed below after the shorthand SQL statements for creating tables.

view employee_skills employees skills

7. To configure your data model settings, click the Settings button.

   

8. In the Settings dialog box, in the Table Settings section, enter OC in the Object Prefix field.

   

9. In the Additional Columns section, click to select the Audit Columns check box.

   

10. In the Generation section, select Yes for Include Drops and Apex Enabled options. Click Save Changes. Next, from the right pane of the Quick SQL app, copy the automatically generated SQL statements to the clipboard.



11. Access your Oracle Application Express workspace.
12. To create a script from the generated SQL in Quick SQL, open the Script Editor. Click SQL Workshop and select SQL Scripts.

    

13. Click Create.
14. Paste the automatically generated SQL statements copied from Quick SQL in a preceding step into Script Editor. Enter a name for the script and click Run.

    

15. Click Run Now.

    

16. Verify created objects. Click View Results.

    

17. Review the results displayed.

    

18. Verify the EMPLOYEES table. Click SQL Workshop, click Object Browser and then select OC_EMPLOYEES from the left pane.

    

19. Verify the SKILLS table. Select OC_SKILLS from the left pane.

    

Next Tutorial

Develop an Oracle APEX App on Oracle Exadata Express Cloud