Home » SQL & PL/SQL » SQL & PL/SQL » How to Find out which time Tirgger got fired
icon9.gif  How to Find out which time Tirgger got fired [message #223836] Mon, 12 March 2007 00:30 Go to next message
vidya2005
Messages: 36
Registered: July 2005
Location: bangalore
Member
Hello experts,

Is there any way to find out when means in which
time trigger has fired. If it's possible to know
then please tell me.


Thanks
Vidya
Re: How to Find out which time Tirgger got fired [message #223859 is a reply to message #223836] Mon, 12 March 2007 02:07 Go to previous messageGo to next message
pravin3032
Messages: 51
Registered: November 2006
Location: eARTH
Member
1 check your trigger defination
2.if you have timestamp column for record added date and updated date in base table you will get the time when the trigger fired.

Re: How to Find out which time Tirgger got fired [message #224139 is a reply to message #223859] Tue, 13 March 2007 04:10 Go to previous messageGo to next message
vidya2005
Messages: 36
Registered: July 2005
Location: bangalore
Member
Hi Pravin,

Where to check the trigger deffination.

Regards
Vidya
Re: How to Find out which time Tirgger got fired [message #224151 is a reply to message #224139] Tue, 13 March 2007 05:05 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I'm quite curious too - How exactly will the trigger definition let us know when the trigger fired?
Re: How to Find out which time Tirgger got fired [message #224292 is a reply to message #224139] Tue, 13 March 2007 14:31 Go to previous message
pravin3032
Messages: 51
Registered: November 2006
Location: eARTH
Member
hi

need both of your attention Mr JRob you too!

i said to check trigger defination assuming you dont know the base table on which trigger is defined.
you will get trigger def. from user_source dictionay table.
from trigg def. check under which event trigger fires -- insert/update/delete.if you have timestamp column in base table to store information for when row inserted/upadeted/deleted
you will know when trigger last time fired SUCCESSFULLY.

I am not sure this is the best approch to find it but it will helps you.

Pravin

[Updated on: Tue, 13 March 2007 14:40]

Report message to a moderator

Previous Topic: Trigger Vs Alerts
Next Topic: Copy long raw to long raw from pl sql
Goto Forum:
  


Current Time: Sun Dec 11 00:23:23 CST 2016

Total time taken to generate the page: 0.08160 seconds