The Oracle Database Cloud Service and Application Express 4.2 include a set of business productivity applications and sample code. All of these applications are easy to use, support mobile devices, and are installable in a few clicks. Productivity applications can be unlocked for customization and learning purposes. Of course, Oracle can only provide support for locked applications. Productivity applications are not the same as sample applications, because sample applications are unlocked by default.

Examples of productivity applications are the project tracker and checklist manager. Examples of sample applications are error handling, interactive reports, and the mobile sample application.

Plan for the future

In addition to these packaged business applications and sample code, the Oracle Database Cloud Service supports third-party applications. All third-party applications will go through a validation process to ensure the safety of the application and the protection of user data in the Oracle Database Cloud Service environment (Oracle Certification).

The following screenshot shows an example of the available packaged applications:

The Oracle Database Cloud Service and Application Express 4.2 include the RESTful Web Services wizard that allows you to easily create a web service to access any SQL statement or PL/SQL program. This wizard makes it easy to create RESTful web services to be used by applications outside the Database Cloud Service.

RESTful web services have three main characteristics:

Terminology used in the RESTful Web Services wizard are listed in the following table:

The RESTful Web Services wizard

On the home page of the RESTful Web Services wizard, a report on web services modules exists. The module named oracle.example.hr is shown in the following screenshot. The home page can be reached through SQL Workshop/RESTful Web Services.

Click on the module and you will see two logical parts of the page. On the left-hand side, you will see a list of various templates within the module. On the right-hand side, you will see the attributes of this module.

The next example steps through the RESTful Web Services creation wizard are as follows:

1. Start the wizard by clicking on Create Template, as shown in the following screenshot:

   

2. Give the template a name, for example empall/.

   Note

   Remember that the forward slash at the end of the URI is required.

   

3. The next step is to create the handler.

   You can do that by clicking on Create Handler just below the RESTful service (empall/):

   

4. Now select the HTTP method for your RESTful service.

   The HTTP methods available here are GET (equal to select), DELETE (equal to delete), PUT (equal to insert), and POST (equal to update):

   

5. From the available source types, select Query. As the output format you can choose between JSON and CSV. Select JSON.

   

6. The Source field contains the source code, which will be executed when the web service is called. Enter the following query in this field:

   Select * 
   From EMP
   Order by deptno, ename

   

7. Click on the Create button to save the template.

   We can test the web service by clicking on the Test button and check the outcome of the web service. An example of a possible outcome, depending on your data, is shown in the following screenshot:

   

   Tip

   Remark

   To have this nice layout, I installed the Firefox browser JSON viewer plug-in from https://addons.mozilla.org/en-us/firefox/addon/jsonview/.

   A report region can be created to show the output from the RESTful web services as shown in the preceding example.

The data load feature enables us to load or unload data from our Oracle Database Cloud Service. The utility enables you to upload data from a text file, an XML document, or a spreadsheet. This utility is accessed from the Application Express SQL Workshop.