Run from File

When you open a query, there is an option Run from File. This is used for running a large SQL script. When you use Run from File, the SQL statements are run directly from your file without first being written to the SQL window. The avoids the overhead of loading the SQL into the window; in addition, you can use this feature to start processing at a particular line in the file.

When you select Run from File:

• text such as the following is placed in the SQL window: <file>bigfile.sql <startline>1
• you can, if you wish, change this to another file, or use a different value for startline. This makes it easy to restart from a particular point in a file.
• run the file by clicking on Run or hitting F5.
• the Run Multiple SQL statements window will be displayed, showing you the individual SQL statements in the file. Run these by clicking on Run or F5. See Run Multiple SQL Statements for more information on this window.

You can open multiple files using Run from File. If you have multiple <file> statements in the Run SQL window (on separate lines), AQT will open all these files in the Run Multiple Statements window.