批量查询数据库内容

#/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