oracle12c的show指令,Oracle 12C R2-新特性-SQLPLUS提供查看历史命令的功能

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;