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
>
Connect to the database and run them. You can do it manually or put them
in a sqlplus script and run the script. You will not disconnect and
reconnect between each command.
Received on Thu Jun 22 2006 - 12:42:09 CDT
