Database Reference
In-Depth Information
Figure 2-21.
The SQL Workshop Utilities home page
You've already seen the Query Builder, which gives users the ability to visually cre-
ate queries.
The
Data Workshop
provides tools that import and export data in many different
formats including comma or tab separated, XML, or spreadsheet data. These tools also
help you manage files that you have loaded into either the text or spreadsheet reposit-
ory.
The
Generate DDL
wizard allows you to choose a schema associated with the work-
space and generates a script that can be used to re-create some or all of the objects with
that schema based on your selection. The generated script doesn't include any insert
statements for the data that resides in the database objects, but it's a good way to easily
re-create the underlying objects an application might use.
The
Methods on Tables
wizard generates an Application Programming Interface
(API) based on a specific table or set of tables. For each table selected (up to ten named
tables), the generated package contains a procedure for each of the following actions:
Insert, Update, Delete, and Select. The benefit of using table APIs instead of accessing
the table directly is that any required validation logic can be included once, in the API,
and accessed from various alternate interfaces including APEX.
User Interface Defaults
allow you to define default display attributes to APEX re-
gions and items. The utility lets you manage these UI defaults at two different levels:
