Home » SQL & PL/SQL » Client Tools » "X Rows Selected" message being suppressed (SQL*PLUS v10.2)
"X Rows Selected" message being suppressed [message #461382] Thu, 17 June 2010 11:12 Go to next message
andrewmurphy
Messages: 9
Registered: June 2010
Location: Ireland
Junior Member
Am using the SQL*PLus tool via a command line to execute some simple "select" scripts. Scripts work fine in what they produce - except for something that is missing occasionally.

For SOME scripts, I'm getting no "xx Rows Selected" type messages at the bottom and I can't figure out why. When no data si returned in some (different) scripts I do get a "no rows selected" message. Am looking for this message in all outputs as an "end of report"-style marker.

No complicated SQL logic and I have the following standard settings applied into each script.

set linesize 500
set pagesize 50000
set tab off
set wrap off
set colsep '|'

I have 20 years of coding experience so it's not a basic error....albeit I'm far more familiar with MS SQL Server product set as well as the PL/SQL Developer client front ends for Oracle.

Any advice/pointer given would be welcome.
regards
Re: "X Rows Selected" message being suppressed [message #461383 is a reply to message #461382] Thu, 17 June 2010 11:13 Go to previous messageGo to next message
BlackSwan
Messages: 26669
Registered: January 2009
Location: SoCal
Senior Member
SQL> SET FEEDBACK 0
Re: "X Rows Selected" message being suppressed [message #461384 is a reply to message #461382] Thu, 17 June 2010 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 66940
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
set feedback on/off
to set on/off the feedback message.

Regards
Michel
Re: "X Rows Selected" message being suppressed [message #461387 is a reply to message #461384] Thu, 17 June 2010 11:26 Go to previous messageGo to next message
andrewmurphy
Messages: 9
Registered: June 2010
Location: Ireland
Junior Member
many thanks. working now. something new learnt.

Can't figure out how it operated intermittently, given all scripts executed within same overall unix script and with exact same SQL options....oh well...that's life, etc!
Re: "X Rows Selected" message being suppressed [message #461390 is a reply to message #461387] Thu, 17 June 2010 11:30 Go to previous messageGo to next message
BlackSwan
Messages: 26669
Registered: January 2009
Location: SoCal
Senior Member
the default is 6 which means when 5 or fewer rows are return no FEEDBACK is provided.
Re: "X Rows Selected" message being suppressed [message #461391 is a reply to message #461387] Thu, 17 June 2010 11:31 Go to previous messageGo to next message
Michel Cadot
Messages: 66940
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you:
set feedback N
then you get the feedback only if there are more than N retrieved rows, this may explain the differences.

Regards
Michel
Re: "X Rows Selected" message being suppressed [message #461465 is a reply to message #461391] Fri, 18 June 2010 03:18 Go to previous message
andrewmurphy
Messages: 9
Registered: June 2010
Location: Ireland
Junior Member
Resolved and educated. Thanks.
Previous Topic: Problems during binding SpotLight to the instance
Next Topic: sysdba access from Isqlplus
Goto Forum:
  


Current Time: Thu Apr 09 03:16:49 CDT 2020