Re: attaching one trigger to multiple tables

Create a trigger on each table to all call the same packaged procedure.

Use dynamic sql within this procedure to build the actual sql using a parameter passed in from each table trigger to form the table name

nigel

-- 
-----
to reply, remove cavemen from below:
fred.nillspam.barney_at_yahoo.com
"M" <greenandkind_at_yahoo.com> wrote in message
news:c7b3da1b.0405121422.65cbd1b4_at_posting.google.com...


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