[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生效.