dbTalk Databases Forums  

SQL*Plus 'xxx rows selected' echo line

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss SQL*Plus 'xxx rows selected' echo line in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
absinth
 
Posts: n/a

Default 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.


Reply With Quote
  #2  
Old   
Barbara Boehmer
 
Posts: n/a

Default Re: SQL*Plus 'xxx rows selected' echo line - 05-24-2005 , 08:01 PM






scott@ORA92> set feedback 1
scott@ORA92> select systimestamp from dual;

SYSTIMESTAMP
--------------------------------------------
24-MAY-05 06.00.14.453000 PM -07:00

1 row selected.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.