Skip to Main Content

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!

How to execute multiple sql query in one time?

860159May 7 2011 — edited May 8 2011
HI
I'm trying to convert my sql project In Oracle. In sql i could run multiple select statement/query in once and they return in multiple table result respectively. but in oracle its not executed.
like:
sqlQry := "Select * from abc; select * from qwe; select * from kkk; select * from xyz"
its return 4 table abc, qwe,kkk,xyz to my dataset result

how it is possible in oracle 10g
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 5 2011
Added on May 7 2011
4 comments
4,535 views