- 论坛徽章:
- 0
|
使用:<<comm进行多行注释,执行注释的时候,报错了:
:<<comm
echo `date` > log1.txt
sqlplus -S rap/infinity@aiobs7 >>log1.txt << end
set linesize 172
set heading off
set feedback off
set pagesize 50000
set echo off
spool all
select (case when instr(a.login,'@',1,1)=0 then a.login else substr(a.login,1,instr(a.login,'@',1,1)-1) end)||':'||
(case when instr(a.login,'@',1,1)=0 then a.login else substr(a.login,1,instr(a.login,'@',1,1)-1) end)||':'||
substr(a.password,6)||':'||
c.bandwidth||':'||
nvl(c.ipaddr,'0.0.0.0')||':'||
b.name||':'||
b.certificatetype||':'||
b.industry||':'||
b.address||':'||
b.domainname||':'||
'内蒙古'||':'||
'中国'||':'||
nvl(b.contact_phone,b.lx_phone)||':'||
b.fax
from service_t a ,
user_t b,
serviceenus_t c
where a.userid=b.id
and a.id=c.id
and a.type='enustime';
spool off
exit
end
comm
/obsdata1/aiobs71/test/getoutall>% getout.sh
getout.sh: /tmp/sh109232: 不能打开 |
|