I know that I can execute a script file (ex. filename.sql) from a
batch or SqlPlus console with the command @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...

cavalcantipino (AT) yahoo (DOT) it wrote:
Wrap the script files in another script. So you might have a script
called "wrapper.sql" which contains the following lines:

@script1.sql
@script2.sql
@script3.sql
....
@scriptN.sql

Then just run "@wrapper" in SQL*Plus. It will execute the scripts in order.

HTH,
Brian


--
================================================== =================

Brian Peasland
dba (AT) nospam (DOT) peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

Brian Peasland wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On 6 Set, 15:39, DA Morgan <damor... (AT) psoug (DOT) org> wrote:

Thank you Brian for wrapper solution.

Daniel, where can I find something about using DBMS_SCHEDULER? Thank
you again!

cavalcantipino (AT) yahoo (DOT) it wrote:
Oracle docs at http://tahiti.oracle.com.
My demos in Morgan's Library at www.psoug.org
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org