开发者

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

开发者 https://www.devze.com 2023-01-12 23:38 出处:网络
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

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

精彩评论

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