Home » SQL & PL/SQL » SQL & PL/SQL » create a autorunning trigger..(merged) (oracle 9i)
create a autorunning trigger..(merged) [message #439079] Thu, 14 January 2010 02:14 Go to next message
abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal
Member
i need to run the update of one column every 5 mins....its like auto refreshing.....how can i achieve that using trigger...
Re: create a autorunning trigger..(merged) [message #439081 is a reply to message #439079] Thu, 14 January 2010 02:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
A trigger is executed when an action is made, it is not executed on time base.
If you want to execute a procedure regularly use a job.
DBMS_JOB

Regards
Michel
Re: create a autorunning trigger..(merged) [message #439085 is a reply to message #439081] Thu, 14 January 2010 02:44 Go to previous message
abhi_shakya
Messages: 50
Registered: September 2009
Location: Nepal
Member
ok thanx
Previous Topic: SEQ NR Generation based on Code
Next Topic: Trigger Error
Goto Forum:
  


Current Time: Sat Dec 03 12:29:30 CST 2016

Total time taken to generate the page: 0.24582 seconds