Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> SQL*Plus 'xxx rows selected' echo line

SQL*Plus 'xxx rows selected' echo line

From: absinth <absinth_at_gmail.com>
Date: 24 May 2005 17:45:06 -0700
Message-ID: <1116981905.953678.241750@g44g2000cwa.googlegroups.com>


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. Received on Tue May 24 2005 - 19:45:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US