Re: SqlPlus and sql script files
Date: Fri, 07 Sep 2007 15:23:11 -0000
[Quoted] 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
[Quoted] Thank you Brian for wrapper solution.
Daniel, where can I find something about using DBMS_SCHEDULER? Thank you again! Received on Fri Sep 07 2007 - 17:23:11 CEST