shell语言 调用数据库

#!/usr/bin/ksh
>33333.txt
sqlplus -s 数据库连接串<<!>>33333.txt
set colsep |
set pagesize 0
set linesize 1000
set serveroutput on size 10000 
set pagesize 0
set head off
select '#############' a  from dual;
select * from  usr_134.bc_ist_record where result_code='118185044';
!

输出结果 进行规整

sed "s/  *//g" 33333.txt

sed "s/\t//g"  33333.txt

 

sed  -i '1i\date     be_id  domain  proc_type   error_code  count(*)' /onip/app/billsharedb/lyy/error.txt

sed "s/  *//g" | sed "s/\t//g" >> 1234.txt

循环调用物理库

#!/usr/bin/ksh

sql_mod="set line 300\n set head off\n set feed off\n set pagesize 0\n set colsep \"|\" \n col acct_id for 9999999999999999999\n  alter session set nls_date_format='yyyymmddhh24miss'; \n"
>1234.txt

echo