Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> attaching one trigger to multiple tables
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.
Received on Wed May 12 2004 - 17:22:05 CDT
![]() |
![]() |