All geek questions in one place

Oracle SQLPlus: how to display sqlplus command output without having to issue spool off command first?

Is there a way to display the output of the sqlplus command without having to issue the spool off command first?

I wind the results of the sqlplus session onto the file and at the same time close the file. The reason for this is that for a table with very long rows, the format is easier to see from the file. The problem is to see the output that I have to give the spool off command every time I run the command in sqlplus.

Can I configure sqlplus so that after I issue the spool command, all the output can be viewed immediately in the file.

(Forming a way to display lines on the screen is not an option.)

thank

+3
source share
5 answers

If you are buffering the results of several statements, you can turn off buffering and then turn it back on between each expression. When you turn on buffering again, add the append keyword so that it continues in the same file rather than overwriting it.

If you want to see the results of a single query in your spool file, you can split the query into several queries that return specific ranges of data. This will be slower, but you can cycle through to get faster feedback.

+1
source

SPOOL is really designed to create an SQL * Plus output file for any purpose: logging, input to another process, etc. There is no means to view the output of its output.

, IDE, , . , Quest TOAD Allround Automation PL/SQL Developer, spring , Oracle own ( ) SQL.

+2

, ( spool ), .

+1

, - SQLPlus - SQLPlus LINESIZE, SQLPlus ? .

+1

, - , " ":)

SQLDeveloper, , sqlplus, SQLDeveloper , sqlplus.

, sqlplus sqldeveloper , 1/2 , , sqlplus, SQLDeveloper, ,

, , , , . , ?

, , , , "spool off" . baretail (http://www.baretail.com), .

0
source

Source: https://habr.com/ru/post/1749379/

More articles:


All Articles