Re: Basic question | run multiple queries without reconnecting

Anoop wrote:
> Hi all,
>
> I have a very basic question...
>
> How can you run multiple queries w/o reconnecting to the database? I
> cannot use stored procedures.
>
> What I have is a set of 10-12 queries like this:
> audit all by <acct> by access;
> audit alter sequence by <indiv acct> by access;
> audit alter table by <acct> by access;
> audit comment table by <cct> by access;
> audit grant procedure by <acct> by access;
> audit grant sequence by <acct> by access;
> audit grant table by <acct> by access;
> audit grant type by <acct> by access;
> audit lock table by <acct> by access;
>
> But in order to run them, I do not want to establish a connection for
> each of the statements. I am using Oracle 9i and Java as the
> programming language.
>
> Thanks,
> Anoop

First nothing you've written is a query. These are DCL statements and the solution is as follows:

BEGIN

   <statement 1>;
   <statement 2>;
   <statement n>;

It is called an anonymous block.

You can find examples in Morgan's Library at www.psoug.org. Look up "ANONYMOUS BLOCKS."

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org