新特性:sqlplus中查看执行sql语句记录

Oracle 12.2及以上版本

SQL> history
SP2-1650: History is off, use "SET HIST[ORY] ON" to enable History.
SQL> set hist on    #开启记录
SQL> history
SP2-1651: History list is empty.
SQL> select * from dual;

DUM
---
X

SQL> history
  1  select * from dual;

SQL>

Related Posts