SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

run two different select statements

benjoDec 22 2009 — edited Dec 23 2009

guys,

need your help. i want to run two different sql select statements in oracle on a single run.

select count(*) from table_a;
select count(*) from table_b;

i don't want to use stored procedure or run it as script. is this possible? In MSSQL, it can run two different sql select statments and produce the results in a single run.

Regards,

benjo

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2010

Added on Dec 22 2009

#select, #sql

11 comments

5,143 views