SQL Workshop

The SQL Workshop shown in Figure 9-4 provides tools to view and manage database objects.

Figure 9-4 SQL Workshop

Description of Figure 9-4 follows
Description of "Figure 9-4 SQL Workshop"

The Object Browser shown in Figure 9-5 lets you to use a tree control to view object properties and create new objects. The read-only database objects that are aggregated and cleansed are available for you to review and organize for data mining. Figure 9-4 shows the schema associated with the Retailer Workspace schema.

Figure 9-5 Contextual Area

Description of Figure 9-5 follows
Description of "Figure 9-5 Contextual Area"

You can use the SQL Commands tool to enter ad-hoc SQL. The Query Builder can be used to create join queries using drag and drop. Figure 9-6 shows how to execute the ad hoc PL/SQL block.

Figure 9-6 SQL Commands

Description of Figure 9-6 follows
Description of "Figure 9-6 SQL Commands"

The SQL Scripts shown in Figure 9-7 can be used to store and run scripts. Use the Data Workshop to load and unload text, DDL, and spreadsheet data.

Figure 9-7 SQL Scripts

Description of Figure 9-7 follows
Description of "Figure 9-7 SQL Scripts"

Use RESTful Services to manage web service definitions declaratively using SQL Query and to test the service modules from the web browser. Figure 9-8 shows a list of RESTful service modules.

Figure 9-8 RESTful Services

Description of Figure 9-8 follows
Description of "Figure 9-8 RESTful Services"

You can create a new RESTful Service module by clicking Create and setting the resource handler with a query or an anonymous PL/SQL block responsible for handling a particular HTTP method.

Figure 9-9 Resource Handler

Description of Figure 9-9 follows
Description of "Figure 9-9 Resource Handler"

APEX SQL Workshop Guide is available at http://docs.oracle.com/database/apex-5.1/AEUTL/toc.htm