Execute SQL Statements and Command Files

After you execute a SELECT statement, the result set appears on the Results tab in the Results pane. By default, row numbers appear to the left of the result set.

• Using Text Completion
  The text completion option supplies you with complete keywords and object names as you type.
• Inserting Comments
  Use comments to attach explanatory text to SQL statements or statement blocks.
• Look Up Tables, Columns, and Procedures
  While you are entering commands in Interactive SQL, you can look up the names of tables, columns, or procedures stored in the current database and insert them at your cursor position.
• Indent SQL Statements
  Increase or decrease indentation of SQL statements, or change the default number of spaces indented.
• Clearing the SQL Statements Pane
  Clear the SQL Statements pane when you no longer want to work with the SQL code displayed on the pane.
• Executing All SQL Statements
  If multiple SQL statements exist in the SQL statements pane, you can execute all statements at once.
• Executing Selected SQL Statements
  If multiple SQL statements exist in the SQL statements pane, you can execute one or more selected statements.
• Executing SQL Statements One at a Time
  To execute SQL statements individually, use the Single Step option. This is useful when debugging.
• Configuring the Execute Statements Toolbar Button
  Configure the Execute Statements button to either execute all SQL statements or only execute selected statements.
• Cancelling a SQL Statement
  A cancel operation stops the current processing and prompts for the next command. The Interrupt The SQL Statement button on the Interactive SQL toolbar cancels a command.
• Executing Command Files
  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 save command files.
• Executing COMMIT and ROLLBACK Statements
  There are multiple ways to execute COMMIT and ROLLBACK statements.
• Customizing the Interactive SQL Interface
  You can configure settings for the tabs and panes in Interactive SQL using the Options window.
• Interactive SQL Window Reference
  Use the Interactive SQL window to enter SQL statements and view results and messages.
• Data Menu Window Reference
  Use the windows available from the Data Menu to export a result set and import data.
• Tools Menu Window Reference
  Use the windows available from the Tools menu to configure Interactive SQL settings, search for table and procedure names to insert into your queries, and edit your queries.
• Interactive SQL Keyboard Shortcuts
  Learn about the keyboard shortcuts available in Interactive SQL.