论坛 › shell › shell demo 1

admin 发表于 2022-3-22 13:14:44

shell demo 1

#!/bin/bash
list="OBJS SCORE T1 TEST"
log=r.log
for tab in $list
do
sqlplus -s zhyu/zhyu>>$log<<EOF
set heading off
select '$tab'||':'||count(*) as row_counts from $tab;
EOF
done
exit

查看完整版本: shell demo 1