Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Trigger on several tables with time limit?
I thought of building a kind of super/multi trigger for Oracle and
would like to get an second oppinion if it is a good idea. Or if
there already exists good solutions for this...
What I thought of doing is to build a stand alone server that can be used to define triggers on several tables. Lets say I want to trigger when:
"(table1.value1 > 12) and (table2.value2 < table4.value4)"
Not neccesarily using this made up syntax, or some other combination of changes in several tables.
I also would like to have some kind of temporal capability, for example I would like to trigger on:
"table1.value1 < 12 and (table2.value1 < 12 within one hour)"
I also would like the changes in the table to be able to be apart from each other in time. So that first I wait for a change in one table and then, few hours later, a change in other table will trigger my super-trigger (or whatever it should be called)
Am I inventing a wheel here? I have the need for this capability? What about you?
Cheers
/Marv
Received on Thu Feb 20 2003 - 09:26:28 CST