Oracle SQLPlus: How to display the output of a sqlplus command without having to first issue the spo
Posted
by ziggy
on Stack Overflow
See other posts from Stack Overflow
or by ziggy
Published on 2010-06-10T11:12:15Z
Indexed on
2010/06/10
11:23 UTC
Read the original article
Hit count: 388
Is there a way to display the output of a sqlplus command without having to first issue the spool off command?
I am spooling the results of a sqlplus session to a file while at the same time tailing the file. The reason for this is that for table with very long rows the format is easier to look at from a file. The problem is to see the output i have to issue the spool off command everytime i run a command in sqlplus.
Can i configure sqlplus so that after i have issued the spool command all the output is viewable straight away on the file.
(Formating the way the rows are displayed on the screen is not an option. )
THanks
© Stack Overflow or respective owner