linux下，shell脚本与oracle交互脚本

wapysun

浏览: 21495237 次
性别:
来自: 杭州

最近访客更多访客>>

devcang

hunankeda110

辽东小小

apex53

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

2012-06 ( 77)
2012-05 ( 587)
2012-04 ( 177)
更多存档...

脚本 Linux Oracle C C++

wc -l 7*.txt

. ~/.bash_profile

cd /data/intfdata/ba/gtdata

database_pass=`cat /home/gmcc/database_work.conf`

---签约
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='A' and amt=300 " field="|" file="7月份数据_签约_a类_300.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='A' and amt=800 " field="|" file="7月份数据_签约_a类_800.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='A' and amt=1000 " field="|" file="7月份数据_签约_a类_1000.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='A' and amt=1200 " field="|" file="7月份数据_签约_a类_1200.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='A' and amt=2000 " field="|" file="7月份数据_签约_a类_2000.txt"

sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='B' and amt=300 " field="|" file="7月份数据_签约_b类_300.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='B' and amt=800 " field="|" file="7月份数据_签约_b类_800.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='B' and amt=1000 " field="|" file="7月份数据_签约_b类_1000.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='B' and amt=1200 " field="|" file="7月份数据_签约_b类_1200.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='B' and amt=2000 " field="|" file="7月份数据_签约_b类_2000.txt"

sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='C' and amt=300 " field="|" file="7月份数据_签约_c类_300.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='C' and amt=800 " field="|" file="7月份数据_签约_c类_800.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='C' and amt=1000 " field="|" file="7月份数据_签约_c类_1000.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='C' and amt=1200 " field="|" file="7月份数据_签约_c类_1200.txt"
sqluldr user=$database_pass query="select distinct servnumber||'||||' from tb6_lh_hhf_gj_temp8 where sfzshf='是' and lb='C' and amt=2000 " field="|" file="7月份数据_签约_c类_2000.txt"