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

来源:这里教程网 时间:2026-03-03 12:10:58 作者:

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

相关推荐