Using Oracle Developer to work on your Oracle SQL database presents ... you can set output for a database connection and check the results of queries and commands as they occur in your test ...

run the SQL query and dump the output to a text file, FTP the file to the central workstation, do the same thing on SQL box2, then run the analysis on the workstation. Once the two files are on ...

When your SQL query is ready, you can run the query immediately or you can add a title, change its options, limit its output, and so on, to make the report look better. See Viewing the SQL Code, ...