Re: SqlPlus and sql script files

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

[Quoted] 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

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

HTH,
Brian

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

Brian Peasland
dba_at_nospam.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