<

Shell中重定向<

1.EOF也可以换成其他任意的字符，大小写不论，只要成对出现即可
2. 第二个EOF必须顶格写，否则会报错。
3. EOF中如果带有 $变量的时候会将$和变量名变成空格

如果不希望EOF中的$符号不希望被当成默认的转义字符需改成\$

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;
spool /tmp/status.log;
select decode(status,'OPEN',0,2) "status" from v\$instance;
spool off;
exit;
EOF

======================问题:=====================================================
[oracle@ORACLE-master ~]$
[oracle@ORACLE-master ~]$ 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;
> spool /tmp/status.log;
> select decode(status,'OPEN',0,2) "status" from v$instance;
> spool off;
> exit;
> EOF
select decode(status,'OPEN',0,2) "status" from v
*
ERROR at line 1:
ORA-00942: table or view does not exist

[oracle@ORACLE-master ~]$

==============正确=========================================

[oracle@ORACLE-master ~]$ 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;
> spool /tmp/status.log;
> select decode(status,'OPEN',0,2) "status" from v\$instance;
> spool off;
> exit;
> EOF

0

ITPub博客

EOF中的$符号不被当成默认的转义字符需改成\$

最新文章