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 History window. To access the History window, press Ctrl+H, or click SQL » History 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 History window.

You can copy statements from the History window to use elsewhere, by selecting the statements in the History window, and then pressing Ctrl+C or clicking the Copy button. Click OK to copy the selected statements to the SQL Statements pane of Interactive SQL. When you copy multiple statements, they are separated by the statement delimiter (a semicolon by default).

You can save statements in text files so that you can use them in a subsequent Interactive SQL session by pressing Ctrl+S or clicking the Save History As .SQL File button, specifying a location and name for the .sql file, and then clicking Save. You can also save SQL script files in a Favorites list.

The contents of the History window persist between Interactive SQL sessions. You can remove the selected statements from the history by clicking Delete. You can remove all statements from the history by clicking Clear History. Neither action can be undone.

You can also recall statements without the 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 ...;

 See also