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