Syntax

HIST[ORY] [n RUN | EDIT | DEL[ETE]] | [CLEAR | LIST]

Enables users to run, edit, or delete previously used SQL*Plus, SQL, or PL/SQL commands from the history list in the current session. You can enable or disable the HISTORY command in the current SQL*Plus session by using the SET HISTORY command.

The HISTORY command enables you to:

• List all entries in the command history list.

• Run an entry in the command history list.

• Edit an entry in the command history list.

• Delete an entry from the command history list.

• Clear all entries in the command history list.

Terms

HIST[ORY]

Lists all entries in the command history list.

n

Represents an entry in the command history list. An asterisk (*) indicates the last used command in the command history list.

RUN

Enables you to execute entry n from the command history list.

EDIT

Enables you to edit entry n in the command history list, using the default text editor. After you edit entry n in the command history list and save the changes, a new entry is created at the end of the list. When the number of entries in the command history list reaches the maximum limit, the oldest entry in the list will be cleared to accommodate the new entry.

DEL[ETE]

Enables you to delete entry n from the command history list. After you delete an entry from the history list, the list is reordered to reflect the most recent changes.

CLEAR

Enables you to clear all entries in the history list. Once cleared, the history list cannot be recovered.

LIST

Lists all entries in the history list. This is the same as using the HIST[ORY] command by itself.

Usage

You can use the SQL*Plus DEFINE command to define the variable, _EDITOR, to hold the name of your preferred text editor. For example, to define the editor used by EDIT to be vi, enter the following command:

DEFINE _EDITOR = vi

EDIT attempts to run the default operating system editor if _EDITOR is undefined. See the DEFINE command for more information.

HIST[ORY] 5 RUN

HIST[ORY] 3 EDIT

HIST[ORY] 2 DEL[ETE]

HIST[ORY] CLEAR

SQL> set history on
SQL> show history
History is ON and set to "100"
SQL> set history off
SQL> show history
History is OFF
SQL> set history 1000
SQL> show history
History is ON and set to "1000"

SQL> show history
History is ON and set to "100"
SQL> show user
USER is "SYSTEM"
SQL> desc dual
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 PROD                                               VARCHAR2(1)

SQL> select * from dual;

D
-
X

SQL> history 4 run

D
-
X

SQL> history
  1  show history
  2  show user
  3  desc dual
* 4  select * from dual;

SQL> history
  1  show history
  2  show user
  3  desc dual
* 4  select * from dual;
SQL> history 2 run
USER is "SYSTEM"
SQL> history
  1  show hist
* 2  show user
  3  desc dual
  4  select * from dual;