Re: attaching one trigger to multiple tables

M wrote:

> Hello,
>
> I am adding 3 columns and attaching a trigger to 10 tables (Oracle9i).
> The column names and specs, and the trigger are the same for all the
> tables. All 10 table names begin with the same word. Is there a way of
> doing it in a single statement for all the tables (using some kind of
> a wildcard character or a loop)?
>
> Thank you,
> G.

Kind of.
You can use SQL to write a new SQL file and then run the new SQL file. Received on Wed May 12 2004 - 19:09:33 CDT