The type of query statements available depends on the type of data source selected on the previous page. Selecting the SQL data source provides the following methods of creating a query statement for your report:
in the Data Source definition text box, type the SELECT statement to retrieve the data for your report.
click Query Builder for an easy graphical method of creating a query that does not require a knowledge of SQL.
click Import Query to select a file that contains a query, which is copied into the Data Source definition text box.
click Connect to display the Connect dialog box for the SQL data source.
Note: Pluggable data sources (PDSs) may use this page of the wizard or they may have their own. If they use this page, you should check the PDS documentation.
Query Definition displays the Query Editor for the selected PDS. Once the query is defined using the Query Editor, the Data Source definition text box shows a text summary of the query definition, generated by the PDS and reflects the settings for the query.
Import Query is currently not supported.
Connect displays the Connect dialog box for the selected PDS.
Copyright © 1984, 2005, Oracle. All rights reserved.