Home » SQL & PL/SQL » SQL & PL/SQL » Triggers
Triggers [message #211886] Tue, 02 January 2007 22:59 Go to next message
Messages: 5
Registered: December 2006
Location: DUBAI
Junior Member
Hello Experts,

I would like a create a trigger in Oracle8i which fire itself everyday in the morning at 7:00am to insert some selected data into a specified table. This has to be in routine until I disable the trigger.

Please help me in achieving this.

Thanks in advance.

Abdul Mannan
Re: Triggers [message #211892 is a reply to message #211886] Wed, 03 January 2007 00:08 Go to previous message
Barbara Boehmer
Messages: 8723
Registered: November 2002
Location: California, USA
Senior Member
What you need is a scheduled job, not a trigger. Look up dbms_job.submit in the online documentation.
Previous Topic: Trigger Compile Error
Next Topic: How to get Local System date ?
Goto Forum:

Current Time: Thu Jul 20 18:10:00 CDT 2017

Total time taken to generate the page: 0.08469 seconds