| how do i set off [message #57796] |
Tue, 08 July 2003 08:17  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
|
when i spool i see SQL>promt,PL/SQL procedure successfully completed, and SQL> spool off I want to set these there off.. how do i do.. help please
|
|
|
|
|
|
|
|
| Re: how do i set off [message #57806 is a reply to message #57805] |
Tue, 08 July 2003 12:14  |
Joe
Messages: 138
Registered: November 1999
|
Senior Member |
|
|
sidd,
I guess it helps when I actually read your question :) When you call spool inside sqlplus, then issue a command, then issue a spool off. The spool off will be in the spool file. However, if you create a .sql script, only the output will be in the logfile:
set feedback off --you don't really need this, but thought you might want to omit the last line!
spool somefile.lst
select * from some_table;
spool off
Hope this helps.
joe
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
