When you execute a statement, Interactive SQL automatically saves it in a history list that persists between Interactive SQL sessions. Interactive SQL maintains a record of up to 50 of the most recent statements.

You can view the entire list of statements in the Command History window. To access the Command History window, press Ctrl+H, or click the Open A List Of Past SQL Statements button on the toolbar.

The most recent statements appear at the bottom of the list. To recall a statement, select it and then click OK. It appears in the SQL Statements pane of Interactive SQL. You can select multiple statements from the Command History window.

You can also recall statements without the Command History window. Use the Recall Previous SQL Statement and Recall Next SQL Statement icons in the toolbar to scroll back and forward through your statements, or press Alt+Right Arrow and Alt+Left Arrow, respectively.

CREATE USER testuser
 IDENTIFIED BY testpassword;

CREATE USER testuser
 IDENTIFIED BY ...;

 Copying statements from the Command History window

 Saving statements from the Command History window

 Removing statements from the Command History window