Online Documentation for Data Export for Oracle
Step 3 - Specifying queries
Use this step to define queries to export their results.
To add a query, use the Add Query button, or right-click within the Queries list and select the Add Query context menu item. You can enter SQL text for each query directly using the Query Text editor area or load an existing query from an external *.sql file by pressing the Load Query button. While inputting query text, it is also possible to save your queries by clicking the Save Query button or clear the content of the editor by clicking the Clear Query button.
To rename a query, right-click it in the Queries list and select the Rename Query context menu item.
To delete a query, select it in the Queries list and press the Remove Query button, or right-click the query and select the Remove Query context menu item.
To delete all queries (i.e. empty the Queries list), click the Clear All button, or right-click within the Queries list and select the Remove All Queries context menu item.
Note: If none of the tables was selected at the previous step, the Next button will be enabled only when the query is added.
The context menu of query editor area contains most of the standard text-processing functions (Copy, Paste, Select All). You can also save your query as a default query by choosing the corresponding context menu item. It will be automatically copied to the default query editor.
Don't show this step anymore
When you are done, press the Next button to proceed to the next step.