for FILE in `ls ${csvfilepath}*.CSV`
do
rowcount=`grep '繂瑔瑔' $FILE | wc -l`
tablename=`echo $FILE |cut -d '.' -f 1`
VALUE=`sqlplus -S /nolog <<EOF
set heading off feedback off pagesize 0 verify off echo off numwidth 20
conn $username/$password
select count(*) from ${tablename};
exit
EOF`
echo "The table $tablename of rows is $VALUE. The $FILE rows is $rowcount"
done