Re: Multiple selects or insert statements in a single execution..

"Karthikeyan" <karthi_srs_at_rediffmail.com> a écrit dans le message news: bocqk4$77k$1_at_news.mch.sbs.de...
> Hi all,
> I am just a beginner to Oracle.
> I am wondering how to execute the multiple select statements or insert
> statements on different tables in a single execution.
>
> for eg.
> select * from Person;
> select * from Book_Details;
>
> The above select statements I want to execute in a single execution and
not
> by storing these statements in some file and exectuing that file.
>
> Please help me how to solve this.
>
> Note: I can't put these select queries in a stored procedure as these
> queries will be dynamically generated and I need to execute these in a
> single execution.
>
> Regards,
> Karthi
>
>

Hello,

By saying "single execution", do you mean that both queries should be executing at the same time
and not one after another ? What is the very purpose of what you are trying to do ?

Can you tell the group about which dev tools you use to "dynamically generate" your queries ?
It will help us to answer your question.

Alkos Received on Thu Nov 06 2003 - 04:57:15 CST