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

"Alkos" <azerty_at_nospam.org> wrote in message news:bod9ed$35d3_at_news.rd.francetelecom.fr...
>
> "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
>
>

Hi,

    What I meant by "Single Execution" was that If I am executing these select statements
from SQLPLus I don't want to give in two steps.

    Its like, at "SQL > prompt", I want to exeucte this statements in a batch.
I have my own program by which when the user chooses the tables from the GUI, I will generate the select statements. Those statements I want to execute in a "single execution".

Am I clear ?

Thanks in Advance,
Karthi Received on Thu Nov 06 2003 - 07:33:58 CST