Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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