Oracle by Example brandingDeploy an Oracle APEX App on Oracle Exadata Express Cloud

section 0Before You Begin

This is the third 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.

This tutorial shows you how to deploy an app on an Oracle Application Express instance on the cloud. 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.

section 1Export an App From a Workspace

To deploy an app, you first export the app from the workspace where you developed the app. Log in to your Oracle Database Exadata Express Cloud Service instance and open the Application Express workspace.

  1. Click App Builder drop-down menu in your Application Express workspace where you developed the Skills app.
    App Builder
    Description of the illustration apex_on_eecs_deploy_app_step1_1.png
  2. Click the Export option.
    App Builder-Export
    Description of the illustration apex_on_eecs_deploy_app_step2_1.png
  3. Click Database Applications.
    App Builder-Export
    Description of the illustration apex_on_eecs_deploy_app_step3_1.png
  4. Click the 104 Skills option in the Application drop-down list.
    Export Application
    Description of the illustration apex_on_eecs_deploy_app_step4_1.png

    5. This is a descriptive paragraph that follows a list item.

  5. Click the Export button.
    Export Application
    Description of the illustration apex_on_eecs_deploy_app_step5_1.png
  6. When you export an app, it is converted into an sql file. Click OK to save the exported app file to your computer.
    Save exported app
    Description of the illustration apex_on_eecs_deploy_app_step6_1.png

section 2Import the App into a Workspace

You will now import the app into another Application Express workspace on the cloud. For example, you can import an app into a production workspace. Log in to your Oracle Database Exadata Express Cloud Service instance that has the production workspace.

  1. Click App Builder.
    App Builder
    Description of the illustration apex_on_eecs_deploy_app_step1_2.png
  2. Click Import.
    App Builder-Import
    Description of the illustration apex_on_eecs_deploy_app_step2_2.png
  3. Click Browse to select the app file you want to import.
    Browse to app file
    Description of the illustration apex_on_eecs_deploy_app_step3_2.png
  4. The file f104.sql is selected. Click Next.
    App file
    Description of the illustration apex_on_eecs_deploy_app_step4_2.png
  5. Click Next in the Import wizard.
    Import Application Wizard
    Description of the illustration apex_on_eecs_deploy_app_step5_2.png
  6. Click Install Application.
    Import Application Wizard
    Description of the illustration apex_on_eecs_deploy_app_step6_2.png
  7. The application has been installed.
    Install successful
    Description of the illustration apex_on_eecs_deploy_app_step7_2.png
  8. To create the underlying tables in your production workspace of Application Express, go to Quick SQL and generate the SQL statements again. Use the shorthand SQL and settings described in the second tutorial in this series. However, remove the INSERT statements from the shorthand SQL. The shorthand SQL should look like this:
    9.  employees /
      name /nn
      email /lower
      city
      country /values US, US, MX, CA
      skills /
          skill /nn /upper /values Java, Java, Java, JS, JS, SQL, PHP, Perl, ABCS, APEX, Python
         proficiency num /nn /check 1, 2, 3, 4
  9. Create the SQL script using the Script Editor in the production workspace of Application Express. Review the first tutorial in this series, second section steps 11 through 19.
  10. Run the app you created and deployed.

more informationWant to Learn More?