不显示SQLPLUS提示

2024-05-11 • 问答

我正在尝试使用bash脚本与sqlplus连接。当我执行下面的脚本时，将显示SQLPLUS横幅。

脚本下方：

$ORACLE_HOME/bin/sqlplus "/ as sysdba" <<EOF
  set echo off
  set heading off
  spool bind.txt
  select * from DBMS_LOCK_ALLOCATED where name = '$uservar';
  spool off
  exit
EOF

脚本输出

oracle@dmoTA01:~/script> ./before_bind.sh

SQL*Plus: Release 11.2.0.3.0 Production on Wed Nov 27 11:54:01 2019

Copyright (c) 1982,2011,Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning,OLAP,Data Mining and Real Application Testing options

SQL> SQL>   2    3    4  Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning,Data Mining and Real Application Testing options
oracle@dmoTA01:~/script>

我不想显示“ SQL * Plus：11版.............实际应用程序测试选项”行。我该怎么办？

yuagqian 回答：不显示SQLPLUS提示

您需要将-S添加到sqlplus才能将其切换为静音模式：

$ORACLE_HOME/bin/sqlplus -S "/ as sysdba" <<EOF
  set echo off
  set heading off
  spool bind.txt
  select * from DBMS_LOCK_ALLOCATED where name = '$uservar';
  spool off
  exit
EOF

bash display linux oracle sqlplus

本文链接：https://www.f2er.com/3023848.html

不显示SQLPLUS提示

yuagqian 回答：不显示SQLPLUS提示

大家都在问