Operating System - HP-UX
1748239 Members
3773 Online
108759 Solutions
New Discussion юеВ

Oracle SQL Select not showing "rows selected" with less than 6 rows selected

 
SOLVED
Go to solution
Michele (Mike) Alberton
Regular Advisor

Oracle SQL Select not showing "rows selected" with less than 6 rows selected

Hi Folks,

my Oracle 9i does not show at the end of SQL queries the "rows selected" message when less than 7 entries are retrieved (>0).

Is there any way to get the message regardless of the resulting number of lines ?

Thanks !

Mike
3 REPLIES 3
Sanjay Kumar Suri
Honored Contributor
Solution

Re: Oracle SQL Select not showing "rows selected" with less than 6 rows selected

Use following command at SQL

set feed[back] {6|n|off|on}

to change the set value.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Michele (Mike) Alberton
Regular Advisor

Re: Oracle SQL Select not showing "rows selected" with less than 6 rows selected

You're great,

and so fast !

Thanks a lot,

Mike
Sanjay Kumar Suri
Honored Contributor

Re: Oracle SQL Select not showing "rows selected" with less than 6 rows selected

Thanks Mike

More precisely give the command:

SQL> set feedback 1

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.