- 论坛徽章:
- 0
|
awk '{
a=$1;
q="'\''";
s=substr($1,1,16);
p=substr($1,1,11);
if(a ~ /^89/)
{
print "declare resulte varchar(20);\n begin\n select count(*) into resulte from im.im_inv_imsi_use where inv_id between "q $1 q" and "q s $2 q";\n
if resulte = 0 then dbms_output.put_line("q $1" and "s $2 " ok"q");\n
else dbms_output.put_line("q $1" between "s $2 " warning have problem!!"q");\n
end if;\n
end;\n/"
};
if(a ~ /^46/)
{
print "declare resulte varchar(20);\n begin\n select count(*) into resulte from im.im_inv_imsi_use where iccid between "q $1 q" and "q p $2 q";\n if resulte = 0 then dbms_out.put_line( "q $1 "and "p $2 " ok "q");\n
else dbms_output.put_line("q $1 between "p $2 " have problem!!"q");\n
end if;\n
end;\n/"
}
}' IMSI.txt>>jh.sql |
|