Re: SqlPlus and sql script files

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 06 Sep 2007 06:39:45 -0700
Message-ID: <1189085979.7092_at_bubbleator.drizzle.com>


Brian Peasland wrote:
> cavalcantipino_at_yahoo.it wrote:

[Quoted] >> I know that I can execute a script file (ex. filename.sql) from a
>> batch or SqlPlus console with the command _at_filename.sql
>> There is a command to execute many .sql script files without launch
>> them one to the time?
>>
>> Thank you for the help and sorry for my poor english...
>>

>
> Wrap the script files in another script. So you might have a script
> called "wrapper.sql" which contains the following lines:
>
> _at_script1.sql
> _at_script2.sql
> _at_script3.sql
> ...
> _at_scriptN.sql
>
> Then just run "_at_wrapper" in SQL*Plus. It will execute the scripts in order.
>
> HTH,
> Brian

In addition they can be run as external jobs using DBMS_SCHEDULER if you have 10g or above.

-- 
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
Received on Thu Sep 06 2007 - 15:39:45 CEST

Original text of this message