Multiple Query Results in Single Tab

[Steve Eubanks]

Forgive me if this has been covered before - I didn't find it via search.

Currently, if I create separate queries in a single SQL window, the results are displayed in separate results tabs. Is there a way to get the results to display in a single tab?

Here's a very simplified example, if my SQL window looks like this:

| select
| count(*)
| from wut_application_details;
|
| select
| count(*)
| from wut_person_details;
|
| select
| count(*)
| from wut_application_funnel_steps;

Can I get the three count results to all appear in the same results tab?

Thanks!

 

[patch]

I think you should use the 'Command File' option for this.

 

[patch]

What you can also do is write a query like this:

with wadc as
 (select count(*) wut_application_details_count
    from wut_application_details),
wpdc as
 (select count(*) wut_person_details_count
    from wut_person_details),
wafsc as
 (select count(*) wut_application_funnel_steps_count
    from wut_application_funnel_steps)
select *
  from wadc
 cross join wpdc
 cross join wafsc

 

[Buzz_ss]

union all

 

[Jens Naumann]

... or like that

select (select count(*) from wut_application_details) wad_count,
(select count(*) from wut_person_details) wpd_count,
(select count(*) from wut_application_funnel_steps) wafs_count
from dual;