SQL*Plus 'xxx rows selected' echo line -
05-24-2005
, 07:45 PM
Hi,
Is there some way to FORCE SQL*Plus to always return a figure for the
number of rows selected?
It doesn't always return the number of rows returned.
For example if I do:
SQL> select row_id from CX_BATCH_REF;
ROW_ID
---------------
1
2
3
4
5
6
7
8
9
10
11
ROW_ID
---------------
12
12 rows selected.
Then I do:
SQL> select systimestamp from dual;
SYSTIMESTAMP
---------------------------------------------------------------------------
25/MAY/05 10:42:10.012928 AM +10:00
There is no rows returned line for my second select statement. |