Home » SQL & PL/SQL » SQL & PL/SQL » Regarding Triggers & procedures (merged)
Regarding Triggers & procedures (merged) [message #274596] Tue, 16 October 2007 09:44 Go to next message
dasarishiva
Messages: 3
Registered: October 2007
Junior Member

Hii, Generally triggers are activated when we do particular action like update,Insert or delete operations on the record..
But Can i execute a trigger automatically when the timer has expired if so Kindly give me suggestions how to do it..
Re: Regarding Triggers [message #274597 is a reply to message #274596] Tue, 16 October 2007 09:46 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
As far as I know, Oracle RDBMS does not have any timers (unless you want to consider DBMS_JOBS or similar procedures)

[Updated on: Tue, 16 October 2007 09:47] by Moderator

Report message to a moderator

Re: Regarding Triggers [message #274605 is a reply to message #274597] Tue, 16 October 2007 10:16 Go to previous messageGo to next message
dasarishiva
Messages: 3
Registered: October 2007
Junior Member

Can give me the breif idea that and how to implement that

[mod-edit] removed illiterate IM speak.

[Updated on: Tue, 16 October 2007 12:46] by Moderator

Report message to a moderator

Re: Regarding Triggers [message #274606 is a reply to message #274596] Tue, 16 October 2007 10:21 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
http://tahiti.oracle.com contains the whole Oracle documentation set & you can find your answers there.
Regarding Stored Procedures [message #274611 is a reply to message #274596] Tue, 16 October 2007 10:41 Go to previous messageGo to next message
dasarishiva
Messages: 3
Registered: October 2007
Junior Member

The procedure has to be executed when the timer has set to particular time...Can i know how to implement it and the features available regarding this
Re: Regarding Stored Procedures [message #274613 is a reply to message #274611] Tue, 16 October 2007 10:42 Go to previous message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Do not cross/multi-post
http://www.orafaq.com/forum/m/274605/74940/#msg_274605
Previous Topic: Tracing procedures, triggers, executions
Next Topic: triggers
Goto Forum:
  


Current Time: Wed Dec 07 02:50:41 CST 2016

Total time taken to generate the page: 0.16697 seconds