Create trigger for more than one table
I don't know if this post is better placed into Newbie, Triggers, or Oracle...
I'm helping our dba with an Oracle database port. There are about 100 Oracle tables with fields called UPDATED_DATE that default to SYSDATE on insert through the table definition (in Oracle DDL
"UPDATED_DATE" Date Default SYSDATE Constraint "SYS_C00116266" NOT NULL)
The following posts suggest that we can simulate this behavior with triggers.
http://forums.mysql.com/read.php?10,105767,105769#msg-105769
http://forums.mysql.com/read.php?10,105736,106139#msg-106139
So my question is: Is there a way to create triggers that operate on all tables with a field name of UPDATED_DATE?
Subject
Views
Written By
Posted
Create trigger for more than one table
4733
October 04, 2006 08:55AM
2018
October 04, 2006 10:47AM
2376
October 16, 2006 06:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.