sqlplus在使用EOF時不顯示命令方法-引數-S靜默方式

 SQLPLUS -S  靜默方式執行，  不顯示提示和行號 

 sqlplus -S  /nolog < > connect / as sysdba;
> set heading off;
> set feedback off;
> set echo off;
> set pagesize 800;
> set line  450;
> set echo off;
> set veri off;
> set echo off feedback off pagesize 60 linesize 80 newpage 1 recsep off;
> spool /tmp/status.log;
> select decode(status,'OPEN',0,2) "status" from dba_instance;
> spool off;
> exit;
> EOF


         0
[oracle@marshall test]$ more /tmp/status.log 


         0                                                                      
[oracle@marshall test]$