Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL*Plus 'xxx rows selected' echo line
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
ROW_ID
12 rows selected.
Then I do:
SQL> select systimestamp from dual;
SYSTIMESTAMP