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