Home » SQL & PL/SQL » SQL & PL/SQL » Fire triggers on time events
Fire triggers on time events [message #36220] Mon, 12 November 2001 05:07 Go to next message
Daniel Martin
Messages: 1
Registered: November 2001
Junior Member
Hi,
I'd like to know if a trigger can be fired with time events. In other words, if I can specify to fire a trigger at 14:22pm, or 9:00 am, etc. or they are only DML or Database triggers.

----------------------------------------------------------------------

Report message to a moderator

Re: Fire triggers on time events [message #36232 is a reply to message #36220] Mon, 12 November 2001 09:53 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
stick the code into a procedure, then schedule the proc to run using dbms_job. Timing is not exact (down to seconds) but see the folloing link if you want exact timing.
http://asktom.oracle.com/pls/ask/f?p=4950:8:81472::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:1253700499661,

----------------------------------------------------------------------

Report message to a moderator

Previous Topic: Re: Need help with to_date() function, thanks!
Next Topic: Re: How to Retrieve CLOB withADODB Command Parameter...?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 09:58:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.