Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> attaching one trigger to multiple tables

attaching one trigger to multiple tables

From: M <greenandkind_at_yahoo.com>
Date: 12 May 2004 15:22:05 -0700
Message-ID: <c7b3da1b.0405121422.65cbd1b4@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.
Received on Wed May 12 2004 - 17:22:05 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US