The Enter SQL Query dialog box lets you create complex queries using the standard DBMS SQL syntax. To type in multi-line formatted SQL do the following:
- To get a new line click Enter.
- To tab, press Ctrl+Tab.
- To cut and paste from the clipboard, press Ctrl+X to cut, Ctrl+C to copy, and Ctrl+V to paste.
OK
Click to move to the final dialog box of the wizard.
Cancel
Click to cancel the query. You return to the step in the wizard where you originally invoked the Expert dialog box.
Load
Click to load an SQL statement that has been saved in a file. The Load button activates the Load SQL Query dialog box. This dialog box provides you with access to existing files containing SQL statements (*.sql files). When you load an SQL file, its format is preserved.
Save
Click to save the SQL statement in a file for later use. The Save button activates the Save SQL Query dialog box. Use this dialog box to save newly constructed SQL statements, or modifications to existing statements. When you save an SQL file, its format is preserved.
Once saved, the SQL statement appears in the list of available *.sql files in the Load SQL Query dialog box.
Last Query
Click to load the last query that was executed.