您可以
SET ECHO ON在脚本的开头使用来实现此目的,但是,您必须使用
@而不是
<(也必须
EXIT在末尾添加)来指定脚本:
test.sql
SET ECHO ONSELECt COUNT(1) FROM dual;SELECt COUNT(1) FROM (SELECt 1 FROM dual UNIOn SELECt 2 FROM dual);EXIT
终端
sqlplus hr/oracle@orcl @/tmp/test.sql > /tmp/test.log
测试日志
SQL> SQL> SELECt COUNT(1)从对偶; COUNT(1)---------- 1个SQL> SQL> SELECT COUNT(1)FROM(SELECt 1 FROM dual UNIOn SELECt 2 FROM dual); COUNT(1)---------- 2个SQL> SQL>退出



