To create a SQL query:
In the Data Model view, single-click
in the tool palette.
Click in the main area (canvas region) of the window.
In the SQL Query Statement dialog box, define a SELECT statement for the query:
To use Query Builder for an easy graphical method of creating a query without a knowledge of SQL, click Query Builder.
To import a query from a file, click Import Query.
To enter the SELECT statement yourself, type it in the SQL Query Statement field. Tip: Select the columns in the order you want them to appear in the report output.
Click OK.
Refine the query using either of the following methods:
Right-click the query object, then choose Property Inspector to set desired properties.
Right-click the query object, then choose Data Wizard to specify which fields to display, group fields, and any totals.
Repeat Steps 1 through 5 for each query you want to create.
Note: If you define multiple queries in the Data Model view of your report, the Data page does not appear when you invoke the Report Wizard to default the layout.
Next step
Creating a default layout for a report
Creating a query: XML Query tool
Creating a query: JDBC Query tool
Creating a query: Text Query tool
Creating a query: Express Server Query tool
Creating a query: OLAP Query tool
Creating a query: Ref Cursor Query tool
Copyright © 1984, 2005, Oracle. All rights reserved.