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: 391

Filed under:
|
|

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

Related posts about sql

Related posts about Oracle