Oracle 10g - 确定触发器上次更新的日期
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3534015/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle 10g - Determine the date a Trigger was last updated
提问by danboh
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 application, but when I went to look at the table, it had all triggers disabled.
有没有办法可以确定触发器更新的日期？我问的原因是因为客户抱怨在我们的应用程序中收到一些错误，但是当我去查看表格时，它禁用了所有触发器。
采纳答案by dpbradley
select object_name, object_type, created, timestamp
from user_objects
where object_name = 'nameOfYourTrigger'
The timestamp column will show the last touch.
时间戳列将显示最后一次触摸。
