Merging multiple oracle queries to produce one result

Is it possible to execute the following query as one query?

[code]

select count(*) from tableA;
select count(*) from tableB;
select count(*) from tableC;
select count(*) from tableD;

[/code]

ie. the result to be something like this

|TablA|TableB|TableC|TableD|
|50   |300   |30    |9|

Thanks

5
задан ziggy 5 May 2011 в 14:38
поделиться