topic Oracle SQL Select not showing "rows selected" with less than 6 rows selected in Operating System - HP-UX

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

Michele (Mike) Alberton — Mon, 19 Apr 2004 05:45:38 GMT

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

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

Sanjay Kumar Suri — Mon, 19 Apr 2004 05:57:31 GMT

Use following command at SQL

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

to change the set value.

sks

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

Michele (Mike) Alberton — Mon, 19 Apr 2004 05:59:09 GMT

You're great,

and so fast !

Thanks a lot,

Mike

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

Sanjay Kumar Suri — Mon, 19 Apr 2004 06:03:44 GMT

Thanks Mike

More precisely give the command:

SQL> set feedback 1

sks