You can use Query Builder when creating which three region types?
A.
Interactive Report
B.
SQL Report
C.
Master-Detail Form
D.
Form on a Table
E.
Flash Chart
Explanation:
Query Builder enables you to define queries by dragging and dropping tables and
easily create relationships between objects.
A: Interactive Report – Creates an interactive report based on a custom SQL
SELECT statement you provide. For assistance in writing the SQL query, click
the Query Builder button.
B: SQL Report – Creates a report based on a custom SQL SELECT statement or a
PL/SQL function returning a SQL SELECT statement that you provide. For
assistance in writing the SQL query, click the Query Builder button.
E: See step 8a) below.
Adding a Flash Chart to an Existing Page
To add a flash chart to an existing page:
1. Navigate to the Page Definition. See “Accessing a Page Definition” on page 5-2.
2. Under Regions, click the Create icon.
The Create Region Wizard appears.
3. Select Chart and click Next.
4. For Region, select Flash Chart.5. For Display Attributes
6. On Chart Preview, configure the chart attributes. Click Update to refresh the
preview image.
7. Click Next.
8. For Source:
a. Specify a query by either:
Entering a SQL query in the field provided.
Clicking the Build Query button. When the Build Chart Query Wizard
appears, follow the on-screen instructions.
b. Specify relevant chart attributes. To learn more, click the item label.
9. Click Create Region.
Reference: Oracle Application Express, Application Builder Users Guide, Release 3.2, Creating a
Page from the Application Home Page