hi anbu,

need some pretty advices for my output query.


my script database is :

#!/bin/sh

DAY=`/export/home/oracle/bin/lastdate | nawk '{print $1}'`

/export/home/orahome/bin/sqlplus -s user/pass<<eof
set heading off;
set linesize 100;

spool /export/home/oracle//log/$DAY.log
select ip,host_id from omc_ip ;
spool off;
EXIT;
eof


below is my output :

10.1.0.0 LDDS-IVR-2
10.1.0.0 LDDS-CS-A
10.1.0.0 USSDGsem1
10.1.0.0 USSDGsem2
10.1.0.0 USSDGsby1
10.1.0.0 USSDGsby2
10.1.0.0 USSDGmdn1
10.1.0.0 USSDGmdn2
10.1.0.0 USSDGtbs2
10.1.0.0 LDDS-IVR-1
10.1.0.0 USSDGtbs1
10.1.0.0 LDDS-MAP-B
10.1.0.0 LDDS-CS-B

10.1.0.0 LDDS-MAP-A
10.1.0.0 USSDGtbs3
10.1.0.0 USSDGmdn3
10.1.0.0 USSDGmdn4
10.1.0.0 USSDGsby3
10.1.0.0 USSDGsby4
10.1.0.0 USSDGtbs4

20 rows selected.

i want to throw away the blank line and the "20 rows selected."

any idea?


Thank you

Best Regards,

bucci