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 statements

858164May 10 2011 — edited May 11 2011
hi all

i am wondering if i can execute multiple sql statements in one shot with >> execute immediate command

for example:

i define the variable as X := sql statement
Y := sql statement
z := sql statement

can i do execute immediate (X,Y, Z);

if yes how ?? and if not any possible alternate

thanks
This post has been answered by JustinCave on May 10 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 8 2011
Added on May 10 2011
30 comments
4,529 views