Home » SQL & PL/SQL » Client Tools » set feedback off
set feedback off [message #393593] Mon, 23 March 2009 08:26 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
SQL> set verify off
SQL> set termout off
SQL> set feedback off
SQL> spool on
SQL> spool /home/oracle/test4.txt
SQL> select empno from scott.emp where rownum=1;

EMPNO

--------------------------------------------------------------------------------
7369

Why does it gives feedback?
I dont want to display the output?

Thanks,
Re: set feedback off [message #393594 is a reply to message #393593] Mon, 23 March 2009 08:31 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
That is not what SET FEEDBACK OFF does. Look it up.

SET TERMOUT OFF is what you want I think, but that only works when you execute a file. Putting a query at a command prompt will always show you output.
Re: set feedback off [message #393595 is a reply to message #393593] Mon, 23 March 2009 08:31 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
FEEDBACK returns number of records returned by a query; perhaps FLUSH is what you are looking for? (View SET System Variable document.)
Re: set feedback off [message #394444 is a reply to message #393593] Fri, 27 March 2009 03:09 Go to previous message
rajy_salim
Messages: 204
Registered: January 2008
Location: Beirut - Lebanon
Senior Member
Sorry I didn't get what you exactly want, but if you meant to show only the result (7369) without the column name (empno) and the dashes (-), you need to set the heading off using
SET HEADING OFF

Rajy
Previous Topic: SQL PLUS TIMESTAMP
Next Topic: Need list of Vendors of Toad® for Oracle Xpert Edition
Goto Forum:
  


Current Time: Wed Dec 07 14:37:53 CST 2016

Total time taken to generate the page: 0.09687 seconds