| set feedback off [message #393593] |
Mon, 23 March 2009 08:26  |
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  |
joy_division
Messages: 4963
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 #394444 is a reply to message #393593] |
Fri, 27 March 2009 03:09 |
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
Rajy
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
