写了个shell脚本（testdb.sh）如下：
#!/bin/csh
sqlplus hbjs/hbjs@js_test_10gr2 <<!
select count(*) from dps_module_log where FILE_NAME like 'B%.791' and total_count=0;
!
运行后输出为
SQL*Plus: Release 9.2.0.1.0 - Production on Tue Oct 11 16:23:19 2011
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
SQL>
COUNT(*)
----------
1130
SQL> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options
我只想要1130这个值 希望运行脚本后返回值为1130，该怎么做！！！！
不能借助其他程序或脚本。只运行testdb.sh后便得到数据值
------解决方案--------------------
select 语句之前加以下几个设置
set pagesize 0;
set linesize 1024;
set feedback off;
------解决方案--------------------
slqplus -l -s $1/$2@$3 <<!
set pagesize 0;
select count(*) from tableName;
!
------解决方案--------------------
- SQL code
#!/bin/bshsqlplus -l -s sbs/sbs@topprod << !set pagesize 0;set linesize 1024;set feedback off;select sysdate from dual;exit;!bsh test.sh--result:2011/11/12