Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 application, but when I went to look at the table, it had all triggers disabled.

like image 755
danboh Avatar asked Aug 20 '10 19:08

danboh


1 Answers

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

The timestamp column will show the last touch.

like image 105
dpbradley Avatar answered Sep 22 '22 12:09

dpbradley