Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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...Received on Fri May 14 2004 - 05:09:10 CDT
> 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.
![]() |
![]() |