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

From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Thu, 6 Nov 2003 09:02:09 -0500
Message-ID: <Qc-dnZ7ZT-sPyTeiRVn-tg@comcast.com>

what are you using for your GUI? is your GUI is able to present a list of tables (presumably by selecting from the data dictionary), it must have the capability to process the generated SQL statements. if it is using SQL*Plus to process the statements, and you have no other tools available, then you either have to write the group of statements to a file, or, if on a Unix system (are you creating a shell (g)UI to SQL*Plus?) , you can use what i think is called an 'immediate file', ie

sqlplus << EOF

select ...
select ...
select ...

pause
exit
EOF how are passing commands to SQL*Plus now?

• mcs

"Karthikeyan" <karthi_srs_at_rediffmail.com> wrote in message news:bodi9i$b5i$1_at_news.mch.sbs.de...
>
> "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 - 08:02:09 CST