Toad World® Forums

Editor Ouptut Window


#1

Hi

When I have an editor with multiple tabs, I have all tabs sharing the same output window, forcing me to rerun queries in each tab to view the output each time - a real pain when checkignthe output of one query against another, for instance…

Is there any way I can have each tab with its own output window?

Thanks

Steve

Message was edited by: Dorset Nomad


#2

Do you mean the DBMS output panel at the bottom of the Editor? If so, there is
no way to do that. It just polls for any output that is available and shows it.
I don’t think that there is any way for us to write to dbms_output such
that we could keep it separate for the various tabs. One thing that we could
look at in the future would be to keep it separate if you have the execute in
threads option enabled. In this case we could keep each tab separate because
each tab would have its own session. This is a little more difficult to change
than it appears on the surface so don’t look for it for 10.5, but for the
fall 2010 release we’ll have a little more flexibility for doing these
items.

Michael


#3

Morning Steve,

Dorset Nomad???

Is there any way I can have each tab with its own output window?
If you are meaning the results grid, then the only way is to upgrade to
Toad 10. Previous versions had one set of results in the grid and
regardless of the query showing in the MOE tab, you saw the same
results.

With Toad 10, when you switch MOE tabs, the results grid changes to
match the results of the query showing in the editor.

Cheers,
Norm. [TeamT]

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else. We have checked this email and its attachments for viruses. But you should still check any attachment before opening it. We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes. If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk

Information in this message may be confidential and may be legally privileged. If you have received this message by mistake, please notify the sender immediately, delete it and do not copy it to anyone else.

We have checked this email and its attachments for viruses. But you should still check any attachment before opening it.
We may have to make this message and any reply to it public if asked to under the Freedom of Information Act, Data Protection Act or for litigation. Email messages and attachments sent to or from any Environment Agency address may also be accessed by someone other than the sender or recipient, for business purposes.

If we have sent you information and you wish to use it please read our terms and conditions which you can get by calling us on 08708 506 506. Find out more about the Environment Agency at www.environment-agency.gov.uk


#4

Hi

Thanks! In the meantime I’ve discovered that if I run the script with F9 instead of F5 then the output for each tab remains in place.

SOrry if Ididn’t describe my problem very well - still very new to TOAD and trying to find the best ways of using it!


#5

Ah. I always assume, most times incorrectly, that F9 execution is being used so
I thought that you meant the dbms_output tab, not results data. Yeah, use F9 if
that’s working for you. Script execution is a different beast and designed
for the execution of multiple statements (scripts) in sequence and it supports
most SQLPlus commands.

Michael


#6

Hi
I am new to TOAD. I am on 10.6.1.
When I switch Editor tabs the output panel retains the results of the last executed script run via F5 no matter which tab I select.(Output and Grid)
I have logged a support call but they claim it is functioning as designed.
When I switch tabs the output panel simply flashes as if it wants to redisplay something.

pvw

Message was edited by: paul.vanwegen_921


#7

That’s correct – you only get one Script Output window per editor.

You can open 2 editor windows if you would like independent script output
panels.


#8

Also, there were a couple of support cases that came up recently regarding “Load
and execute script” where multi-selecting files to load and execute would only
execute the last script. This bug has been fixed in the current beta.

If you are executing manually via F5 then Jeff is correct, that’s the way it is
designed. The script engine is also a script debugger and can open new tabs,
step from one script (one Editor tab) into another script/tab. For this reason
there is one script engine and one script output area per Editor instance. You
can retain script history by enabling the “Maintain script history” option in
Toad’s Options. This will create a “History” tab that maintains the terminal
output from each script execution. This tab will fill up fast and consume lots
of memory if your scripts are returning many results.

Michael


#9

You could also spool the output of each tab to a file and use the Compare Files
tool.

Greg


#10

I somehow want to ask a question which looks something similar to the topic but with a bit different requirement. Is there any way of running multiple queries all together and getting the output in the same grid. I know we can use execute script function but it gives the output in separate grids. Please suggest. I am on 9.6.0.27


#11

The same grid? No, that’s not really possible, but you can run multiple queries at the same time.

  1. Go to Options > Oracle > Transactions and check “Execute queries in threads”

  2. Open a new Editor and enter your query and hit F9 to execute

  3. Open a new Editor tab, enter another query, F9.

You can monitor your running queries in the “Query Viewer” sub-tab in the Editor. Once results are ready, switching between Editor tabs will display the correct
data grid results for the each query.

I’m curious, why do you want results from multiple queries in the same grid?

Thanks,

Brad

From: anmol [mailto:bounce-anmol@toadworld.com]

Sent: Thursday, September 19, 2013 9:39 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Editor Ouptut Window

RE: Editor Ouptut Window

Reply by anmol

I somehow want to ask a question which looks something similar to the topic but with a bit different requirement. Is there any way of running multiple queries all together and getting the output
in the same grid. I know we can use execute script function but it gives the output in separate grids. Please suggest. I am on 9.6.0.27

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#12

Why not use the SQL union (all) command – it’s doable with some tweaking in cases where columns are not 100% identical

From: Brad Boddicker [mailto:bounce-ButtonPusher@toadworld.com]

Sent: Friday, September 20, 2013 8:06 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Editor Ouptut Window

RE: Editor Ouptut Window

Reply by Brad Boddicker

The same grid? No, that’s not really possible, but you can run multiple queries at the same time.

  1. Go to Options > Oracle > Transactions and check “Execute queries in threads”

  2. Open a new Editor and enter your query and hit F9 to execute

  3. Open a new Editor tab, enter another query, F9.

You can monitor your running queries in the “Query Viewer” sub-tab in the Editor. Once results are ready, switching between Editor tabs will display the correct
data grid results for the each query.

I’m curious, why do you want results from multiple queries in the same grid?

Thanks,

Brad

From: anmol [mailto:bounce-anmol@toadworld.com]

Sent: Thursday, September 19, 2013 9:39 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] Editor Ouptut Window

RE: Editor Ouptut Window

Reply by anmol

I somehow want to ask a question which looks something similar to the topic but with a bit different requirement. Is there any way of running multiple queries all together and getting the output
in the same grid. I know we can use execute script function but it gives the output in separate grids. Please suggest. I am on 9.6.0.27

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

Image removed by sender.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.