Combine SQL results tabs into one tab?

[Patrick Holmes]

Let's say I have five SQL statements in a SQL window and I execute all five at once. Each statement will be executed and the results of each statement will display in a separate results tab. I have a new employee who has used RapidSQL in the past and he is used to the results of multiple queries being combined into one window/tab. (The output looks like a grid, where the header and data for the first query displays, then the header and data for the next query, and so on--without any regard for whether the queries have the same # of columns or the same column names.) Do you have this feature? (I looked in options but didn't see it.) Do you plan to add this feature? Do you want to see a screen shot?
thanks,
pat holmes

 

[ScottMattes]

I'd like to see a screen shot. Is there some way to get from the beginning of result set A to result set C, or do you have to scroll?

 

[Marco Kalter]

Such a feature is not available in PL/SQL Developer. Different result sets are displayed on different result tab pages.

 

[Patrick Holmes]

Perhaps you'll want to consider having this feature as a future enhancement. Just in case, I will email you (Marco, and also Scott since you asked) a screen shot from RapidSQL.

thanks,
pat

 

[ScottMattes]

I could easily get behind this, though if you do do it Marco I think that each table name needs to be in the grid somehow (maybe its just me, being old and all)

 

[Patrick Holmes]

Regarding Scott's suggestion to show "each table name... in the grid". Note that each of the queries might not be based on a single table but possibly on many tables.

(In fact, a query might not even be based on a table at all--it could be an in-line view such as:
"select x.mycol1, x.mycol2
from (select a.xxx mycol1, b.yyy mycol2
from table1 a, table2 b
where a.id = b.id) x"

thanks,
pat

 

[ed10k]

Personally I like the existing feature:

Different result sets are displayed on different result tab pages.

If I need all results on one page: I use command window.

 

[Worker]

Yeah, I can't say this sounds like a good idea either. Other than being used to having the output this way, why would you prefer the output on a single tab over multiple tabs?

 

[Patrick Holmes]

-- There are many times where I prefer the way PL/SQL Developer works currently, displaying results in separate tab pages. I am *not* suggesting that the "displaying the output in one window" feature should *replace* the way PL/SQL Developer currently works. I am suggesting that it would be nice to have "display in one window" as an option that could be selected, which we could use occasionally only when needed.
-- Regarding the question, "why would I prefer" to have the output in a single tab is that *sometimes* it makes sense to see the data that way. For example, I have a "patient-info" set of queries that looks at the patient table, a child table, three grandchild tables, and eight great-grandchild tables, but all the information is for one patient. In that specific example, it is better and easier to see all the information on one screen. (This request came up because I hired a new employee who prefers RapidSQL just because of this one feature...)
-- I agree that I could use SQL*Plus or some other tool. But my hope is that my programmers and I would be able to use PL/SQL Developer for all of our PL/SQL and SQL programming needs. I would like to be able to never have to use SQL*Plus again ;-)
thanks,
pat holmes

 

[Patrick Holmes]

-- Oops! I just re-read ed10k's reply, and I realize now that he said "command window" and not SQL*Plus. It is true that I can run my pt_info.sql in the command window and still not have to use the dreaded SQL*Plus. Sorry about that!
thanks,
pat

 

[ScottMattes]

Maybe Patrick could share the picture with all here, I liked the output (though I would want it for all the time).

Many enough times I have done multiple queries and had to constantly switch tabs back and forth - this proposal would greatly eliminate that.

 

[Patrick Holmes]

-- I would not prefer this proposed feature for all the time, especially because the export feature would then be confusing. It is a feature I would use sometimes, turning it on when needed
-- I don't know how to post an attachment to this thread, or if that is even possible. However, I will email the RapidSQL screen capture to anyone who is interested (my email: pholmes@ipcm.com)

thanks,
pat holmes