[20181107]18c set feedback显示sql_id.txt

[20181107]18c set feedback显示sql_id.txt

--//简单测试看看.

SQL> select banner from v$version ;

BANNER

----------------------------------------------------------------------

Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production

SQL> set feedback 6 sql_id

SQL> select * from dual ;

DUM

---

X

SQL_ID: 01fwpqgt0jx4p

SQL> select sysdate from dual ;

SYSDATE

------------------

07-NOV-18

SQL_ID: f0wzs9nc663bn

--//这样执行完成后显示sql_id.我也尝试使用18c的client连接10g的数据库.

SQL> select * from v$version ;

BANNER

------------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE    10.2.0.4.0      Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

SQL> set feedback 6 sql_id

SQL> select sysdate from dual ;

SYSDATE

------------------

07-NOV-18

--//没有显示sql_id.

SQL> set feedback only

SQL> select * from dba_tables;

3456 rows selected.

--//set feedback only生效.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/267265/viewspace-2219007/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/267265/viewspace-2219007/