Database Reference
In-Depth Information
sum(DEMO_ORDERS.ORDER_TOTAL) as "SUM_OF_ORDERS"
from
"DEMO_CUSTOMERS" "DEMO_CUSTOMERS_2",
"DEMO_USERS" "DEMO_USERS",
"DEMO_ORDERS" "DEMO_ORDERS"
where
"DEMO_USERS"."USER_ID"="DEMO_ORDERS"."USER_ID"
and
"DEMO_CUSTOMERS_2"."CUSTOMER_ID"="DEMO_ORDERS"."CUSTOMER_ID"
and "DEMO_ORDERS"."ORDER_TOTAL" <500
group by DEMO_USERS.USER_NAME,
DEMO_CUSTOMERS_2.CUSTOMER_ID,
DEMO_CUSTOMERS_2.CUST_FIRST_NAME,
DEMO_CUSTOMERS_2.CUST_LAST_NAME
Although the Query Builder is very useful and allows you to put together a basic
query fairly quickly using a simple GUI, it does have its limitations, such as nested
subqueries and complex unions. We use the Query Builder to get the skeleton of a
query defined; we then take the query to the SQL Commands window or a SQL IDE
and fine-tune it from there.
As a final note, it's worth mentioning that the Query Builder is linked to from sever-
al places in APEX, so any time you're prompted for a SQL statement (for example, as
the basis for a report) you can open the Query Builder in a pop-up window and return
the query to the calling form.
Utilities
The SQL Workshop Utilities section gives you access to tools and reports that help you
view and manage information about the underlying database objects and their data.
This section introduces each tool set and its main purpose. However, the majority of
these tools are very straightforward, so in most cases the deep details are left for you to
explore on your own.
The Utilities home page (as shown in
Figure 2-21
) presents a quick icon-based
menu you can use to reach the individual utility areas. Clicking any one of these icons
takes you directly to the tools page for that category.
