#/bin/bash
name=`cat 2.txt`
for i in $name
do
sqlplus -S mintrade/HTCH2017htch << EOF
set heading off feedback off verify off
SELECT f_sign_account FROM TRADE.T_F_B_DEALER_BANK_RELATION WHERE f_bank_account='$i';
exit;
EOF
done
-S 去除sqlplus进入数据库内容
set heading off feedback off verify off 去除表头
user=`cat 2.txt`
name=`
for i in $user
do
sqlplus -S trade09/trade09 <<EOF
set heading off feedback off verify off
SELECT f_id FROM T_DEALER where f_code='$i';
exit;
EOF
done`
for i in $name
do
sqlplus -S trade09/trade09 <<EOF
set heading off feedback off verify off
SELECT f_name FROM T_DEALER where f_id='$i';
exit;
EOF
done