Linux下Shell脚本与Oracle交互脚本

wc -l 7*.txt. ~/.bash_profilecd /data/intfdata/ba/gtdatadatabase_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"Linux下apt get命令的来历及常见应用Linux下weblogic 关闭和启动（SSH命令）相关资讯 Linux Shell

Linux基础知识：shell基础命令（今 10:39）
Linux系统监控shell脚本（04月09日）
Linux shell脚本编程（03月01日）

Linux shell数组（07月26日）
Linux Shell实现批量关闭局域网中（03月10日）
Linux系统入门教程：如何知道当前（11/27/2015 08:36:09）

本文评论查看全部评论（0）