Hi,
I am writing one unix script to get row count of few tables into one sequential file
my script is like this
$ORACLE_HOME/bin/sqlplus -s <<EOF >output.txt
userid/password@databasename
set verify off
set heading off
set feedback off
select count(*) count from tablel;
select count(*) count from table2;
select count(*) count from table3;
exit;
EOF

I want the output inoutput.txt file like this

table1 30(record count)
table2 40
table3 50

Can you please help me in gettinh this result

Thanks

I actually have a whole process that involves SQLPlus and a whole bunch of queries. I recommend sending the queries to their own files so you can just do a line count; something like this:
#!/usr/bin/ksh
sqlplus -s <<EOF > outfile.txt
username/password@database
set verify off
set heading off
set feedback off
spool table1.csv
select count(*) count from tablel;
spool table2.csv
select count(*) count from table2;
spool table3.csv
select count(*) count from table3;
exit;
EOF

wc -l table1.csv table2.csv table3.csv | awk {print $2"\t: "$1}' > outfile.txt
rm table1.csv table2.csv table3.csv

thanks lankrypt0 for you reply.I will take your Suggestion and will work on this