Recalling commands

When you execute a command, Interactive SQL automatically saves the command in a history list, of up to 50 of the most recent commands, that lasts for the duration of the current session.

You can view the entire list of commands in the Command History dialog. To access the Command History dialog, press Ctrl+H, or click the book icon in the toolbar.

The most recent commands appear at the bottom of the list. To recall a command, highlight the command and click OK. The command appears in the SQL Statements pane.

In Windows, you can also recall commands without the Command History dialog. Use the arrows in the toolbar to scroll back and forward through your commands, or press ALT + Right Arrow and ALT + Left Arrow. (The ALT + Right Arrow and ALT + Left Arrow key combinations do not scroll through commands in UNIX.)

You can also save commands in text files, so that you can use them in a subsequent Interactive SQL session as described in the next section.