902337 wrote:Above sounds like kludge, built upon a hack, layered upon 100% flawed "design"!
Do we have a way to give Follow clause in a db row level trigger in 11g so that this trigger does the job after all the row level triggers have been fired.
The reason being , i would like to create a dynamic trigger on some tables and i would not know the names of the existing triggers and the order of execution
is not defined in them as well.
select trigger_name, trigger_type, triggering_event, table_owner, table_name from user_triggers EMP_TRG4 AFTER EACH ROW INSERT OR UPDATE OR DELETE SCOTT EMP3 EMP_TRG BEFORE EACH ROW UPDATE SCOTT EMP EMP_TRG3 BEFORE EACH ROW UPDATE SCOTT EMP3
rp0428 wrote:I am struggling to decide which is smarter; my goat or my Pet Rock.
Besides it will scale as well as my goat can fly.
How's that 'goat' training coming anyway? You haven't given us an update lately. If it doesn't work out maybe you can hitch it up to your vehicle and help solve some of those "my car won't go" problems we sometimes hear about.
The problem, of course, is that no one responding bothered to ask a lot of critically important questions such as the model and make ... perhaps it is an electric car.
Question: My car won't start tell me what to do? Answer: Fill the tank with Petrol.