Re: How can I run many scripts under a path with SQL*PLUS?

From: gazzag <gareth_at_jamms.org>
Date: 21 Nov 2006 08:01:51 -0800
Message-ID: <1164124910.887299.104150@f16g2000cwb.googlegroups.com>

caifa..._at_gmail.com wrote:
> Using SQL*PLUS I'm trying to run a set of scripts which are under a
> certain path.
>
> The problem is that I may not know how many are them and I won't know
> the names of the .sql files.
>
> Do you know if there is a way that '@' command accepts a directory and
> runs all the .sql files inside the directory?

Operating system details would be very useful here.

I'm not sure how good an idea what you're trying to achieve is. Scripts generally have to be run in a specific order. How would you ensure this happens?

HTH -g Received on Tue Nov 21 2006 - 10:01:51 CST