Re: SqlPlus and sql script files

cavalcantipino_at_yahoo.it wrote:
> On 6 Set, 15:39, DA Morgan <damor..._at_psoug.org> wrote:

>> Brian Peasland wrote:
>>> cavalcantip..._at_yahoo.it wrote:
>>>> 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
>> damor..._at_x.washington.edu (replace x with u to respond)
>> Puget Sound Oracle Users Groupwww.psoug.org

Oracle docs at http://tahiti.oracle.com. My demos in Morgan's Library at www.psoug.org

-- 
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