Re: How to use the start command in pl/sql or loops in a script

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Mon, 8 Nov 1999 15:47:59 +0100
Message-ID: <806nun$g07$1@oceanite.cybercable.fr>

You can dynamicaly generate a script that calls your script for each schema:

spool tmp.sql
select 'start myscript '||username from dba_users where ...; spool off
@@tmp

--
Have a nice day
Michel

Henrik Otto <ottoh_at_space.se> a écrit dans le message : 3826DB79.10B6_at_space.se...
> Hi, Its me again with another question,
> I want to use the sqlplus command 'start <script>' multiple times i.e.
> loop through a bunch of schemas and run the script there. So I either
> want to know how I can run the scripts from pl/sql or how I can make a
> loop or something similar in an sqlplus script. Any ideas?
>
> /Henrik
Received on Mon Nov 08 1999 - 08:47:59 CST