Try this:
Code:
nawk -v v="'" '{ print("select " v ":" $1":" v "||count(*) from "$1";"); }' tablenames > count.sql
sqlplus -s username/password@dbname <<! > count.log
set linesize 1000 pagesize 0 heading off feedback off trimspool on;
@count.sql
!
grep "^:" count.log
