Example 12-1 Examples
The following example executes the fifth entry in the history list:
HIST[ORY] 5 RUN
The following example allows you to edit the third entry in the history list:
HIST[ORY] 3 EDIT
The following example allows you to delete the second entry from the history list:
HIST[ORY] 2 DEL[ETE]
The following example allows you to delete all entries from the history list:
HIST[ORY] CLEAR
The following example shows you how to enable or disable command history, and how to check the command history status:
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"
The following example shows you how to list all entries in the history list:
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;
An asterisk (*) indicates the last used command in the command history list.
The following example shows you how to list all entries in the history list, and then execute the second entry:
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;