Cloud Documentation
Advanced Search


Using Oracle Database Cloud Service - Multitenant Edition
Close Window

Table of Contents

Show All | Collapse

2 Developing Applications for Oracle Database Cloud Service - Multitenant Edition

Topics:

Typical Workflow for Using Oracle Database Cloud Service - Multitenant Edition

To start using your Database Cloud Service, see the typical workflow described in the following table:

Task Description More Information
Request a trial or purchase a subscription to Oracle Database Cloud Service - Multitenant Edition Provide your information, and sign up for a free trial or purchase a subscription. Requesting a Trial Subscription to an Oracle Cloud Service or Purchasing a Subscription to an Oracle Cloud Service in Getting Started with Oracle Cloud
Activate a service After Oracle processes your trial request or purchase order, sign in to My Account and activate the service. Activating Your Trial Subscription or Activating Your Order for an Oracle Cloud Service in Getting Started with Oracle Cloud
Verify the service is activated Once the activation process is complete, sign in to My Services and confirm that your service is now up and available for use. Verifying a Service is Up and Running in Getting Started with Oracle Cloud
Access the service Access your service. Accessing an Oracle Database Cloud Service - Multitenant Edition
Add and manage users Create accounts for your users and assign them appropriate privileges. Managing User Accounts in Getting Started with Oracle Cloud
Monitor the service Check on the day-to-day operation of your service, monitor performance, and review important notifications. Using My Services to Monitor and Administer Oracle Cloud Services in Getting Started with Oracle Cloud
Manage service data Before developing or installing an application or Websheet, import data to be used by your application or Websheet. Managing Data
Develop Oracle Application Express applications and Websheets Create new applications and Websheets. Managing Oracle Application Express Database Applications
Give application and Websheet access to users. Create and authorize users to access your applications and Websheets. Providing Access to Database Cloud Service Applications
Install Oracle Application Express applications You can install packaged applications and sample code. Managing Oracle Application Express Packaged Applications or Sample Code
Manage application users Create and authorize users to access your applications and Websheets. Managing Application Express Application End Users
Monitor Application Express applications Monitor the performance of your applications. Monitoring Application Express Application Activity
Use applications and Websheets How to access and use an Application Express application or Websheet Using Application Express Applications and Websheets
Implement RESTful Web services to access Database Cloud Service data Implement a RESTful Web service consumer or producer for an application. Implementing RESTful Web Services

Importing Data

Tutorial

Topics:

Several methods are available for uploading data in to the database. For an initial data upload on the Oracle Cloud, use Oracle SQL Developer, the Application Express SQL Workshop Data Upload Utility or the Application Express Data Load utility.

The following sections describe the various methods used to load your Cloud Database service with data.

See Also:

For instructions on using RESTful Services to access data, see Implementing RESTful Web Services.

Using SQL Developer for Data Loading

Topics:

Overview of the SQL Developer Data Loading Process

Oracle SQL Developer, along with your Database Cloud Service SFTP server, provides the ability to upload data to your Database Cloud Service. SQL Developer creates a cart containing objects you want to load in to your Database Cloud Service, connects to your Database Cloud Service and deploys data from the cart to the service.

To deploy objects to your service you must perform the following steps:

  1. Create or use an existing Database Cloud Service. See Creating or Using an Existing Database Cloud Service for Data Loading.

  2. Install SQL Developer locally. This application creates the cart of objects to load and to perform the deploying of data from the cart to the service. See Installing SQL Developer.

  3. Add a Cloud connection from SQL Developer to your Database Cloud Service. See Configuring SQL Developer Cloud Connection.

  4. Reset the SFTP account user password. See Setting Up Secure FTP Account.

  5. Using SQL Developer, create a cart filled with objects and deploy to the Database Cloud Service. See Creating and Deploying a Cart of Objects.

  6. Configure the Database Cloud Service to allow access to the service from additional SQL Developer users. See Creating Additional Users for SQL Developer Cloud Connections.

Creating or Using an Existing Database Cloud Service for Data Loading

The first step in the data loading process is to locate the Welcome to Oracle Cloud email received during the Database Cloud Service creation process. If the Database Cloud Service does not yet exist, see Requesting a Trial Subscription to an Oracle Cloud Service and Purchasing a Subscription to an Oracle Cloud Service in Getting Started with Oracle Cloud.

During the service creation process and after your service has been activated, a Welcome to Oracle Cloud email is sent. This email contains important usernames and URLs required for configuring SQL Developer and the Secure FTP site for data loading. See Configuring SQL Developer Cloud Connection and Setting Up Secure FTP Account.

Note:

Save the Welcome to Oracle Cloud email for the Database Cloud Service you are loading with data. This email contains information required for the data loading configuration process.

Installing SQL Developer

SQL Developer creates carts of data structures, DDLs, and data to deploy to the Database Cloud Service. This section describes how to install SQL Developer.

Note:

The Cloud functionality described here requires the SQL Developer Release 3.2 or later.

To install SQL Developer locally, see SQL Developer documentation on the Oracle Technology Network, for installation and setup instructions. http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Note:

If your computer is 64 bit, you may need to run the sqldeveloper.bat file instead of sqldeveloper.exe.

Note:

You must install JDE run time if you do not have JDE run time installed. For installation and setup instructions, see SQL Developer documentation on the Oracle Technology Network at: http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

Configuring SQL Developer Cloud Connection

SQL Developer must have a Cloud connection configured to connect to Oracle Database Cloud Service - Multitenant Edition. The connection can use the default username and password provided for Database Cloud Service.

Additional users can access the service through SQL Developer if they are given the Developer role. See Managing User Accounts and Managing the Roles Assigned to a User in Getting Started with Oracle Cloud.

SQL Developer users can also be added through Application Express using the steps outlined in Creating Additional Users for SQL Developer Cloud Connections.

To add an Oracle Cloud connection:

  1. Run SQL Developer locally.

    The SQL Developer home page displays.

    Description of sql_dev.gif follows
    Description of the illustration sql_dev.gif

  2. Under Connections, right click Cloud Connections.

    The Cloud Connection menu appears.

    Description of sl_dev_connect.gif follows
    Description of the illustration sl_dev_connect.gif

  3. Select New Cloud Connection.

    The Edit Cloud Connection dialog appears.

    Description of empty_edit_cloud.gif follows
    Description of the illustration empty_edit_cloud.gif

  4. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  5. In the My Services box, select the data center and click Sign In to My Services.

  6. If not already signed in, the Sign in dialog displays. Enter the Database Cloud Service credentials and click Sign In.

    My Services appears.

  7. Click Platform Services.

  8. Click the name of the Database Cloud Service.

    The Service Detail page displays.

  9. Under Additional Information, locate the Service SFTP User Name. Make a note of this name for use in a later step.

    Description of additional_info.gif follows
    Description of the illustration additional_info.gif

  10. Click Security.

    The Security page displays.

  11. Click SFTP Users.

    The tab lists the SFTP user accounts for the current identity domain and your services in that domain.

  12. Find the Service SFTP User Name you located in the Service Detail page, click the Menu icon.

    Description of sftp_users.gif follows
    Description of the illustration sftp_users.gif

  13. Select Reset Password.

    The Reset Password dialog appears.

    Description of reset_password.gif follows
    Description of the illustration reset_password.gif

  14. Enter a new password, confirm the new password and click Save.

    The Reset Password confirmation message displays.

  15. To confirm change, click Save.

  16. Go back to the Service Detail page and locate the following information required to configure the new cloud connection:

    • Service Instance URL - The Database Cloud service URL.

    • Service SFTP Host & Port - The SFTP host address.

    • Service SFTP User Name - The SFTP user for this Database Cloud Service.

  17. On the Edit Cloud Connection dialog of SQL Developer, make the following entries:

    • Connection Name - Enter the name for this cloud connection.

    Database

    • Username - Enter the Username required during sign in when accessing the Database Cloud Service.

    • URL - Enter the Service Instance URL from the Service Detail page.

    SFTP

    • Username - Enter the Service SFTP User Name from the Service Detail page.

    • Hostname - Enter the Service SFTP URL from the Service Detail page.

    • Port - Enter 22.

    Your Edit Cloud Connection dialog should look something like this:

    Description of edit_cloud_conn.gif follows
    Description of the illustration edit_cloud_conn.gif

  18. Click OK.

  19. Under Cloud Connections on SQL Developer, open the new cloud connection.

    The Authentication dialog appears.

  20. Enter the Password required during sign in when accessing the Database Cloud Service.

    If you have connected successfully the tables and other objects from the Database Cloud Service will display under Cloud Connections.

    Description of sqldev_tbls.gif follows
    Description of the illustration sqldev_tbls.gif

Setting Up Secure FTP Account

The Secure FTP user password must be reset before you can deploy a data upload. To reset the Secure FTP user password, sign in to My Services, find the SFTP user name, and reset the password.

Note:

The Domain SFTP user will not see the data upload files.

To reset the password for the Secure FTP user account:

  1. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  2. In the My Services box, select the data center and click Sign In to My Services.

  3. If not already signed in, the Sign in dialog displays. Enter the Database Cloud Service credentials and click Sign In.

    My Services appears.

  4. Click Security.

    The Security page displays.

  5. Click SFTP Users.

    The list of SFTP Users appears.

  6. Locate the Secure FTP user and click the Menu icon to the right.

    Description of sftp_users.gif follows
    Description of the illustration sftp_users.gif

  7. Select Reset Password.

    The Reset Password dialog appears.

    Description of reset_password.gif follows
    Description of the illustration reset_password.gif

  8. Enter a new password, confirm the new password and click Save.

    The Reset Password confirmation message displays.

  9. To confirm change, click Save.

Creating and Deploying a Cart of Objects

To create and deploy a cart of objects to a Database Cloud Service:

  1. From SQL Developer, click View.

    The View drop down menu displays.

    Description of view_cart.gif follows
    Description of the illustration view_cart.gif

  2. From the drop down menu, click Cart.

    The Cart window appears on the bottom right.

    Description of empty_cart.gif follows
    Description of the illustration empty_cart.gif

  3. From the left panel, drag the Oracle Database objects you want to load and drop them in to the Cart window on the right.

    Description of full_cart.gif follows
    Description of the illustration full_cart.gif

  4. If you want to include data with the cart deployment, in the Cart window, click the Data check box.

  5. To deploy this cart, click the Deploy Cloud icon at the top left of the Cart window.

    Description of deploy_icon.gif follows
    Description of the illustration deploy_icon.gif

    The Deploy Objects To Cloud dialog displays.

  6. For the Deploy Objects To Cloud dialog, make these changes:

    Under Cloud:

    These options supply information required to connect to the Secure FTP server.

    • Connection - Select the cloud connection for the Database Cloud Service you are deploying to.

    • Title - Enter a title for this deployment. The title is restricted to 15 characters long and alphanumeric characters (a-z, A-Z, 0-9), _ (underscore) and - (dash). No special characters, such as spaces, are allowed.

    • Server - Enter the Secure FTP URL from the Welcome to Oracle Cloud email.

    • Port - Leave as default of 22.

    • SFTP User - Enter the Secure FTP username. See Setting Up Secure FTP Account.

    • SFTP Password - Enter the Secure FTP user's password. See Setting Up Secure FTP Account.

    Under Transfer:

    This option specifies the cart that is deployed.

    • File - Enter or browse for the file you want to deploy. This file is a zip file generated by SQL Developer and contains all objects and optionally data included in the cart.

    Under Deploy DDL:

    These options determine if the DDL will replace existing objects.

    • Do not replace existing destination objects - Creates objects in the destination schema only if objects do not already exist.

    • Replace existing destination objects - Drops existing objects in destination schema if they already exist then creates and optionally loads them.

    Under Deploy Data:

    These options determine how the data is deployed to the destination Database Cloud Service.

    • Truncate destination data - Select this option to truncate existing tables before adding rows.

    • Disable constraints before moving data - Select this option to disable all constraints before moving the data. Re-enables the constraints after the data has been moved.

    • Delimiter - Leave as the default.

    • Line Terminator - Leave as the default.

    • Left Enclosure - Leave as the default.

    • Right Enclosure - Leave as the default.

    Description of deployment.gif follows
    Description of the illustration deployment.gif

  7. Click Apply.

    The Exporting dialog displays.

    Description of exporting.gif follows
    Description of the illustration exporting.gif

Checking Deployment Status

To check on deployment status:

  1. From SQL Developer, under Cloud Connections, open a cloud connection.

  2. Under the open cloud connection on left panel, click Deployments.

    The list of deployments displays.

  3. Under Deployments, click a deployment.

    The deployment DETAILS tab displays at the top right.

    Description of approved.gif follows
    Description of the illustration approved.gif

  4. The status value on the DETAILS page indicates the progress of the deployment.

    • APPROVED - The deployment passed a virus scan and is waiting for processing.

    • PROCESSING - A background daemon process that is scheduled to run periodically, found the APPROVED deployment, changed the status to PROCESSING and started the SQL*loader jobs.

    • PROCESSED - The deployment completed successfully.

    • DENIED - The deployment is not approved.

  5. To view deployment results, click LOGS.

    The LOGS tab displays.

    Description of logs.gif follows
    Description of the illustration logs.gif

  6. To see the latest uploaded tables, on the Connections panel, click the Refresh icon.

    Description of refresh.gif follows
    Description of the illustration refresh.gif

    Note:

    If the Refresh button is not available, the cloud connection is not connected.
  7. From the SQL Workshop Object browser for your Database Cloud Service, view the progress of the data upload and verify that objects and optionally data has uploaded correctly.

SQL Developer for Data Loading in to the Database Cloud Service uses the database utility SQL*Loader to perform the data load. To find out more about restrictions on data loading, see the Oracle Database Utilities book.

Restarting a Deployment

To restart a deployment:

  1. From SQL Developer, click Cloud Connections.

  2. Click the cloud connection.

  3. Click Deployments.

    The list of deployments displays.

  4. Right click the deployment.

    Menu options appear.

    Description of restart_logs.gif follows
    Description of the illustration restart_logs.gif

  5. From the menu options, select Restart.

  6. Follow on-screen instructions.

Removing a Deployment

To remove a deployment:

  1. From SQL Developer, click Cloud Connections.

  2. Click the cloud connection.

  3. Click Deployments.

    The list of deployments displays.

  4. Right click the deployment.

    Menu options appear.

    Description of delete_logs.gif follows
    Description of the illustration delete_logs.gif

  5. From the menu options, select Delete.

  6. Follow on-screen instructions.

Clearing Logs

To clear the log for a deployment:

  1. From SQL Developer, click Cloud Connections.

  2. Click the cloud connection.

  3. Click Deployments.

    The list of deployments displays.

  4. Right click the deployment.

    Menu options appear.

    Description of clear_logs.gif follows
    Description of the illustration clear_logs.gif

  5. From the menu options, select Clear Logs.

  6. Follow on-screen instructions.

Creating Additional Users for SQL Developer Cloud Connections

SQL Developer users can also be added through Application Express.

To add an Oracle Application Express user:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page appears.

    Description of administration.gif follows
    Description of the illustration administration.gif

  2. From the Application Express Builder, click Administration.

    The Administration home page displays.

    Description of manage_users.gif follows
    Description of the illustration manage_users.gif

  3. Click Manage Users and Groups.

    The Manage Users and Groups page appears.

    Description of create_users.gif follows
    Description of the illustration create_users.gif

  4. Click Create User.

    The Create User page appears.

  5. Enter user information. See Managing Application Express Users in the Oracle Application Express Administration Guide.

  6. Under Password, for Require Change of Password on First User select No.

    Description of password.gif follows
    Description of the illustration password.gif

  7. Under User Groups (For authentication against Application Express user account repository only), select at least SQL Developer.

    Description of user_group.gif follows
    Description of the illustration user_group.gif

  8. Click Create User.

Using SQL Workshop Data Upload Utility

The Data Upload utility enables you to upload data from a text file, an XML document or a spreadsheet. The utility is accessed from the Application Express SQL Workshop.

To upload data using the Data Upload utility:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click SQL Workshop.

  3. Click Utilities.

  4. Click Data Workshop.

  5. Click one of the following types of data:

    • Text Data

    • XML Data

    • Spreadsheet Data

  6. Follow on-screen instructions.

To learn more about uploading data with the Data Upload utility, see Using the Data Workshop to Manage Data in Oracle Application Express SQL Workshop Guide.

Using Application Express Application Data Load Utility

Applications with data loading capability allow application end users to dynamically import data in to a table within any schema to which the user has access. End users run a Data Load Wizard that uploads data from a file or copies and pastes data entered by the end user directly in to the wizard.

To learn more about developing Application Express applications with this capability, see Creating Applications with Data Loading Capability in the Oracle Application Express Application Builder User's Guide.

To learn more about how an application end user uses this capability, see About Uploading Data in Oracle Application Express End User Guide.

Managing Data

The SQL Workshop Object Browser enables developers to browse, create, and edit objects in a database. Oracle Application Express has many views defined to help you work with the underlying table structures. The views combine multiple base tables and use meaningful column names to minimize complexity and to be more intuitive to use. See Oracle Application Express API Reference for details of the views defined.

To manage data using Object Browser:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click SQL Workshop.

  3. Click Object Browser.

  4. Browse, create, edit and delete database objects.

    To learn more, see Managing Database Objects with Object Browser in the Oracle Application Express SQL Workshop Guide.

Exporting Data

Topics:

You can create an Oracle Data Pump export of your data and data structure. Export files are downloadable from your secure FTP download area in the outgoing directory. Files are retained for 48 hours. To initiate a download, click the file names using your SFTP client.

Creating an Oracle Data Pump Export

Video

To create an Oracle data pump export of your data, code and data structure:

  1. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  2. Under My Services, select the data center and click Sign In to My Services.

  3. If not already signed in, the Sign in dialog displays. Enter the Database Cloud Service credentials and click Sign In.

    The My Services page appears.

  4. Click the name of the Database Cloud Service.

    The Service Detail page displays.

  5. Under Exports on the left, click Export Data.

    The Export Data page displays.

    Description of data_export.gif follows
    Description of the illustration data_export.gif

  6. Click the Export Data button.

    The Data Export dialog for your service displays.

  7. To include data with the data structures, select Include Data.

    Description of data_exp_data.gif follows
    Description of the illustration data_exp_data.gif

    Note:

    The Oracle Cloud accepts a maximum of 10 data export requests. If you want to create a data export request and you have already reached the maximum, you must delete an old request or wait 7 days for the data export to expire and be purged.
  8. Click Create Data Export.

    The Data Export page displays and lists the requested data export job.

    Description of export_data_list.gif follows
    Description of the illustration export_data_list.gif

  9. Wait until the export status has changed to Available before initiating a download of the data export file. See Downloading a Data Export for further instructions.

    Tip:

    Click Refresh to update the data export status.

Downloading a Data Export

After creating a data export file, see Creating an Oracle Data Pump Export, and the status of the data export file has changed to Available, you can download the file.

To download a data export:

  1. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  2. In the My Services box, select the data center and click Sign In to My Services.

  3. If not already signed in, the Sign in dialog displays. Enter the Database Cloud Service credentials and click Sign In.

    The My Services page appears.

  4. Click the name of the Database Cloud Service.

    The Service Detail page displays.

  5. Under Exports, click Export Data link and make a note of the SFTP host, port and user name.

    Note:

    Your SFTP account password must have been reset at least once since the service was activated. See Setting Up Secure FTP Account

    Note:

    The Domain SFTP user will not see the data export files.
  6. Make sure you have some SFTP client software installed and setup to use for the download. The following are examples of SFTP client software:

  7. For your SFTP client software, create a new connection or SFTP site. You need the host name, username and password. When using FileZilla, enter information then click Connect.

    The following screenshot shows using FileZilla Site Manager to do this.

    Description of site_mgr.gif follows
    Description of the illustration site_mgr.gif

  8. Once connected, you see two folders:

    • upload - this folder is where the SQL Developer Cloud Deployments arrive

    • download - this folder is where the Data Exports are delivered

    Description of folders.gif follows
    Description of the illustration folders.gif

  9. Double click the download folder.

  10. Select the file in the folder to download.

    Description of start_download.gif follows
    Description of the illustration start_download.gif

Managing Oracle Application Express Database Applications

Topics:

Database applications are managed with the Application Express Application Builder. The Application Express Application Builder enables you to create, edit and remove applications.

Creating a Database Application

The Create Wizard enables you to create a complete application containing multiple pages including reports, interactive reports, forms, tabular forms, and master detail forms. The Create Application Wizard is designed to easily and quickly create Oracle Application Express Database applications.

Follow these steps to create a Database application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click Create.

    The first page of the Create Application wizard displays.

  4. Select Database and click Next.

  5. Follow on-screen instructions.

To learn more about creating Database applications, see About Database Applications in Oracle Application Express Application Builder User's Guide.

To learn about using Database applications, see the Oracle Application Express End User Guide.

Modifying a Database Application

To modify a Database application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click the Database application you want to modify.

    The Application Edit page appears.

  4. Make modifications.

To learn more about modifying Database applications, see About Database Applications in Oracle Application Express Application Builder User's Guide.

To learn about using Database applications, see the Oracle Application Express End User Guide.

Removing a Database Application

To remove a Database application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. For the application you want to remove, click Edit.

  4. Under Tasks on the right panel, click Delete this Application.

  5. Follow on-screen instructions.

To learn more about removing Database applications, see About Database Applications in Oracle Application Express Application Builder User's Guide.

To learn about using Database applications, see the Oracle Application Express End User Guide.

Managing Oracle Application Express Websheet Applications

Topics:

Websheet applications are created from the 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.

Creating 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 the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Administration.

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

    The Websheet Database Objects page appears.

  4. Click Create Websheet Database Objects.

    The required schemas and objects display.

  5. Click Next.

  6. To confirm, click Create Tables.

  7. To manage objects, click Manage Websheeet Objects.

  8. To create a websheet, click Create Websheet.

To learn more, see Managing Websheet Database Objects in Oracle Application Express Administration Guide.

Creating a Websheet Application

Before creating a Websheet, required Websheet database objects must exist. See Creating Websheet Database Objects.

To create a Websheet application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click Create.

    This first page of the Create Application wizard displays.

  4. Select Websheet and click Next.

    The Create Websheet page appears.

  5. For Authentication, select one of the following:

    • Oracle Cloud Identity Management (default) - Users of this Websheet application are managed through the Identity Console. See Managing Users and Roles in Getting Started with Oracle Cloud.

    • Application Express - Users of this Websheet application are managed from the Application Express Administrator. See Managing Application Express Users in Oracle Application Express Administration Guide.

  6. Click Create Websheet.

  7. To test the Websheet, click Run Websheet.

To learn more about creating and modifying Websheet applications, see About Websheet Applications 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.

Modifying a Websheet Application

To modify a Websheet application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. For the websheet you want to modify, click Edit.

    The Websheet Properties page appears.

  4. Make modifications.

To learn more about creating and modifying Websheet applications, see About Websheet Applications 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.

Removing a Websheet Application

To remove a Websheet application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. For the websheet you want to remove, click Edit.

    The Websheet Properties page appears.

  4. Click Delete.

    The Confirm Delete page appears.

  5. Click Permanently Delete Now.

To learn more about creating and modifying Websheet applications, see About Websheet Applications 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.

Providing Access to Database Cloud Service Applications

Once an application has been created or installed to an Oracle Database Cloud Service - Multitenant Edition instance, end users with the appropriate authorization and authentication credentials can access it using a Web browser. The application administrator simply provides the end users with the application's URL.

The following URL shows the URL an application end user would use to access an Application Express application 100082 residing within an Oracle Database Cloud Service - Multitenant Edition with an identity domain of trialaejm:

http://database-trialaejm.db.us1.oraclecloudapps.com/apex/f?p=100082

To learn more about using Application Express applications, see Oracle Application Express End User Guide.

Monitoring Application Express Application Activity

Tutorial

You can monitor developer activity and changes to Application Express applications within your service by accessing the Monitor Activity page in the Application Express Builder. The Monitor Activity page features links to over thirty reports that track page views, developer activity, active sessions, login attempts, environment, application errors, and workspace schemas.

Description of activity.gif follows
Description of the illustration activity.gif

To access the Monitor Activity page:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

    Description of apex_home.gif follows
    Description of the illustration apex_home.gif

  2. From the Application Express Builder, click Administration.

    The Administration home page displays.

  3. Click Monitor Activity.

    The Monitor Activity page appears.

To learn more, see Monitoring Activity Within a Workspace in Oracle Application Express Administration Guide.

Managing Oracle Application Express Packaged Applications or Sample Code

Topics:

You can install Oracle Application Express packaged applications and sample code.

  • Packaged Applications. These are applications that can be installed, run and removed. They are fully supported and cannot be modified.

  • Sample Code. These are samples that illustrate a concept or demonstrate a technique. They can be installed, run, removed, viewed and modified.

Installing Packaged Applications and Sample Code

Video

Tutorial

Follow these steps to install a packaged application or sample code:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click the Application Builder.

    The Application Builder home page displays.

  3. Click the Packaged Applications tab.

    The Packaged Applications page displays showing all available packaged applications and sample code.

    Description of archive_app.gif follows
    Description of the illustration archive_app.gif

  4. Locate and click the packaged application or sample code you want to install.

    The application information page displays.

  5. Click Install Application.

  6. For Authentication, select one of the following and click Next:

    • Oracle Cloud Identity Management (default) - Users of this packaged application are managed through the Identity Console. See Managing Users and Roles in Getting Started with Oracle Cloud.

    • Application Express Accounts - Users of this packaged application are managed from the Application Express Administration. See Managing Application Express Users in Oracle Application Express Administration Guide.

  7. On the confirmation page, click Install Application.

  8. If you selected Application Express authentication, you need to add users from Application Express Administration before running the application. See Managing Application Express Users in Oracle Application Express Administration Guide.

  9. If you selected Oracle Cloud Identity Management, the users currently authorized with access to your Oracle Database Service have access to this application. Use the Oracle Cloud portal to add users. See Managing Users and Roles in Getting Started with Oracle Cloud.

  10. Click Run Application.

Modifying Sample Code

After installing sample code, it can be modified just like any other Database or Websheet application you have created or imported. See Modifying a Database Application and Modifying a Websheet Application.

Note:

Installed sample code can be modified. Installed packaged applications cannot be modified.

Removing Packaged Applications and Sample Code

Follow these steps to remove a packaged application or sample code:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click the Application Builder.

    The Application Builder home page displays.

  3. Locate and click the packaged application or sample code you want to remove.

    The application information page displays.

  4. Click Remove.

  5. To confirm, click Remove Application.

Managing Application Express Application End Users

Tutorial

Service administrators add and manage users of Oracle Application Express applications from the Oracle Identity Console or Oracle Application Express Administration. During application creation or installation, the method for managing users is defined.

  • Oracle Identity Console (default). Use the Oracle Identity Console to add and manage application users if Oracle Identity Console is the application's authentication method selected during installation or creation. To learn more, see Managing Users and Roles in Getting Started with Oracle Cloud.

  • Oracle Application Express Administration. Use the Manage Users and Groups page of the Oracle Application Express Administration to add and manage application end users if Application Express is the application's authentication method selected during installation or creation.

    To manage Oracle Application Express users:

    1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

      The Oracle Application Express home page displays.

    2. Click Administration.

      The Administration home page displays.

    3. Click Manage Users and Groups.

      The Manage Users and Groups page appears.

    To learn more, see Managing Application Express Users in Oracle Application Express Administration Guide.

Managing Application Security

Below are some topics that describe how to implement security best practices for Oracle Application Express and Oracle Cloud Database Service. Administrators are primarily responsible for ensuring the security of the Oracle Application Express setup, while developers are responsible for building secure applications.

To learn more, see Managing Application Security in Oracle Application Express Application Builder User's Guide.

Using Application Express Applications and Websheets

Once an application has been created or installed to an Oracle Database Cloud Service - Multitenant Edition instance, end users with the appropriate authorization and authentication credentials can access it using a Web browser. The application administrator simply provides the end users with the application's URL.

The following URL shows the URL an application end user would use to access an Application Express application 100082 residing within an Oracle Database Cloud Service - Multitenant Edition with an identity domain of trialaejm:

database-trialaejm.cloud.oracle.com/apex/f?p=100082

To learn more about using Database and Websheet applications, see the Oracle Application Express End User Guide.

Sending Emails

You can use the APEX_MAIL package to send an email from an Oracle Application Express application. APEX_MAIL contains three procedures. Use APEX_MAIL.SEND to send an outbound email message from your application. Use APEX_MAIL.PUSH_QUEUE to deliver mail messages stored in APEX_MAIL_QUEUE. Use APEX_MAIL.ADD_ATTACHMENT to send an outbound email message from your application as an attachment.

Example:

BEGIN
  APEX_Mail.Send( 'to@email-address.com', 'from@email-address.com', 
                  'This is some test plain text', 
                  'This is some test <b>HTML</b>', 
                  'Test Email Subject' );
  APEX_Mail.Push_Queue_Immediate;
END;
/

Note:

There is a built in limit of 5000 emails in any given 24 hour period. If you try to send more, you get an error.

To learn more, see APEX_MAIL in Oracle Application Express API Reference.

Scheduling Background and Asynchronous Jobs

Background jobs are scheduled by using the CLOUD_SCHEDULER package. Since the Database Cloud Service is a true multi-tenant environment, some aspects of the Oracle Database must be restricted to protect the integrity of both the data and the performance characteristics of the Database Cloud Service.

A Database Cloud Service cannot be allowed to have unlimited access to the creation and execution of jobs, as this would allow a single Service, either by accident or due to malicious intent, to overrun the underlying hardware resources. To address this situation, Database Cloud Service includes an interface which allows the limited use of database jobs.

This interface has the following characteristics:

  • Users are allowed to submit jobs for immediate execution or as scheduled tasks

  • Users are limited to the number of immediate and scheduled jobs. These limits are public. There is a limit of 10 background jobs and 5 active jobs.

  • When a user submits a job, the interface checks to see if the limit for the number of jobs (of the type of the submitted job) has been reached. If the limit has been reached, the call to the interface returns an error.

  • All jobs use a set of Resource Manager consumer groups of different priorities. If a job forces a consumer group to exceed the resource limits of its consumer group, the job is moved to a consumer group with a lower priority.

  • Users are able to use the standard USER_SCHEDULER_% views to determine the status and number of jobs submitted, so they can prevent the return of an error from the submission process and take appropriate corrective actions.

    Note:

    There is a limit of 10 scheduled or defined background jobs and 5 active or running jobs.

The CLOUD_SCHEDULER package is a wrapper that exactly mirrors the DBMS_SCHEDULER package. The only difference between the packages is the CLOUD_SCHEDULER includes a simple procedure for running an immediate job. The following example illustrates the immediate execution of the My_PLSQL_Procedure job:

Begin
   CLOUD_SCHEDULER.RUN_JOB( 'My_PLSQL_Procedure;' ); 
End;
/

To learn more, see DBMS_SCHEDULER in Oracle Database PL/SQL Packages and Types Reference.

For examples, see Examples of Using the Scheduler in Oracle Database Administrator's Guide.

Application Archiving

Topics:

Modifications to your Oracle Application Express applications can be archived to tables in your database schema. Applications that belong to Database Cloud Services with automatic archiving enabled are archived when they are created and when they are changed. The APEX Application Archive packaged application manually archives applications to view, manage and restore application archives.

Note:

The archived application content is counted against your tablespace quota. By default, only 5 application versions are maintained. However, you can adjust this value from the APEX Application Archive packaged application. See Viewing and Managing Application Archives.

Scheduling Daily Automatic Application Archiving

You can schedule daily automatic archiving for all applications that belong to your Database Cloud Service. Automatic daily archiving is enabled and disabled from the Service Details page, under Administration. Database Cloud Services enabled with application archiving generate an archive for applications when they are created and when they are changed. You can also manually archive from the APEX Application Archive packaged application. To learn more, see Manually Archiving Applications.

To view and manage archives, use the APEX Application Archive packaged application. To learn more, see Installing the APEX Application Archive Packaged Application and Viewing and Managing Application Archives.

To schedule automatic application archiving:

  1. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  2. In the My Services box, select the data center and click Sign In to My Services.

  3. If not already signed in, the Sign in dialog displays. Enter the Database Cloud Service credentials and click Sign In.

    My Services appears.

  4. Click Platform Services.

  5. Click the name of the Database Cloud Service.

    The Service Detail page displays.

  6. Under Administration, click Application Archiving.

    The Application Archiving page displays.

  7. Click Application Archiving Update.

    The Application Archiving information displays.

  8. Select Enable Application Archiving.

Note:

The archived application content is counted against your tablespace quota. By default, only 5 application versions are maintained. However, you can adjust this value from the APEX Application Archive packaged application. See Viewing and Managing Application Archives.

Managing and Viewing Application Archives

Topics:

The APEX Application Archive packaged application views and manages archives. Application archives are performed when the Database Cloud Service is enabled for automatic application archiving or when a manual archive is performed. To learn more, see Scheduling Daily Automatic Application Archiving and Manually Archiving Applications.

Installing the APEX Application Archive Packaged Application

Before you can use the APEX Application Archive packaged application, it must be installed.

To install the Application Archive packaged application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click the Application Builder.

    The Application Builder home page displays.

  3. Click the Packaged Applications tab.

    The Packaged Applications page displays showing all available packaged applications and sample code.

    Description of archive_app.gif follows
    Description of the illustration archive_app.gif

  4. Locate and click the APEX Application Archive application.

    The application information page displays.

    Description of archive_app_info.gif follows
    Description of the illustration archive_app_info.gif

  5. Click Install Application.

  6. For Authentication, select one of the following and click Next:

    • Oracle Cloud Identity Management (default) - Users of this packaged application are managed through the Identity Console. See Managing Users and Roles in Getting Started with Oracle Cloud.

    • Application Express Accounts - Users of this packaged application are managed from the Application Express Administration. See Managing Application Express Users in Oracle Application Express Administration Guide.

  7. On the confirmation page, click Install Application.

  8. If you selected Application Express authentication, you need to add users from Application Express Administration before running the application. See Managing Application Express Users in Oracle Application Express Administration Guide.

  9. If you selected Oracle Cloud Identity Management, the users currently authorized to have access to your Oracle Database Service have access to this application. Use the Oracle Cloud portal to add users. See Managing Users and Roles in Getting Started with Oracle Cloud.

  10. To test the application, click Run Application.

Running the APEX Application Archive Application

The APEX Application Archive packaged application views and manages application archives. Before you can run this application, it must be installed. To learn more, see Installing the APEX Application Archive Packaged Application.

To run the APEX Application Archive packaged application:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Application Builder home page displays.

  3. For APEX Application Archive, click Run.

    The APEX Application Archive application home page appears.

Viewing and Managing Application Archives

The APEX Application Archive packaged application views and manages application archives. Before you can run this application, it must be installed. To learn more, see Installing the APEX Application Archive Packaged Application.

To view and manage application archives:

  1. Run the APEX Application Archive application as described in Running the APEX Application Archive Application.

  2. Click the Manage Archives button.

    The Archives page displays.

  3. To change the maximum number of archives, click Adjust.

    The Preferences dialog appears.

  4. For Max Versions, enter the maximum number of archive versions to save, then Apply Changes.

  5. To remove archives, click Purge All Archives.

    The Purge dialog appears.

  6. For Purge Action, select the action to perform.

  7. Click Purge Archive.

Manually Archiving Applications

You can manually archive applications from the APEX Application Archive packaged application.

To manually archive applications:

  1. Install the APEX Application Archive packaged application as described in Installing the APEX Application Archive Packaged Application.

  2. Run the APEX Application Archive application as described in Running the APEX Application Archive Application.

    The APEX Application Archive home page appears.

  3. Click Archive Applications.

  4. Follow on-screen instructions.

Implementing RESTful Web Services

RESTful Web services enable the declarative specification of RESTful services used to access the database. These services work with the Oracle Application Express Listener to enable the consumption of these services.

Video

Tutorial

To create a RESTful Web service:

  1. Access the Database Cloud Service. See Accessing an Oracle Database Cloud Service - Multitenant Edition.

    The Oracle Application Express home page displays.

  2. Click SQL Workshop.

  3. Click RESTful Services.

  4. To create a RESTful Web service, click Create.

  5. Follow on-screen instructions.

To learn more about implementing RESTful Web services, see Using RESTful Services in Oracle Application Express SQL Workshop Guide.

Calling SOAP and RESTful Web Services

The APEX_WEB_SERVICE package enables you to integrate other systems with Application Express by allowing you to interact with Web services anywhere you can use PL/SQL in your application. The API contains procedures and functions to call both SOAP and RESTful style Web services. It contains functions to parse the responses from Web services and to encode/decode in to SOAP friendly base64 encoding.This API also contains package globals for managing cookies and HTTP headers when calling Web services whether from the API or by using standard processes of type Web service. Cookies and HTTP headers can be set before invoking a call to a Web service by populating the globals and the cookies and HTTP headers returned from the Web service response can be read from other globals.

Note:

All Web services must be secured. Only HTTPS services are supported. Simple HTTP requests will be rejected. The proxy server that is usually configurable is preset as an Oracle provided HTTP proxy server and not changeable by users.

To learn more, see APEX_WEB_SERVICE in Oracle Application Express API Reference.