开发者

Oracle 10g - Determine the date a Trigger was last updated

Is there a way you can determine the date when a trigger was updated? The reason why I ask is because a costumer complained about receiving some erros in our 开发者_StackOverflow中文版application, but when I went to look at the table, it had all triggers disabled.


select object_name, object_type, created, timestamp
from user_objects
where object_name = 'nameOfYourTrigger'

The timestamp column will show the last touch.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜