Command files are text files that contain SQL statements, and are useful if you want to run the same SQL statements repeatedly. You can use Interactive SQL to open, view, run, and export command files.
You can execute command files in any of the following ways from Interactive SQL:
Using the Interactive SQL READ statement
Choosing File > Run Script
Supplying a command file as a command line argument for Interactive SQL
On Windows platforms you can make Interactive SQL the default editor for .sql command files. This lets you double-click the file so that its contents appears in the SQL Statements pane of Interactive SQL.
From Interactive SQL, choose Tools > Options.
The Options dialog appears.
On the General tab, select the Make Interactive SQL the Default Editor for .SQL Files and Plan Files option.
For more information about using Interactive SQL with command files, see: