Home » SQL & PL/SQL » SQL & PL/SQL » How can I to made the records in one of my tables doubled every 5 minutes with a trigger?
How can I to made the records in one of my tables doubled every 5 minutes with a trigger? [message #35996] Mon, 29 October 2001 16:11 Go to next message
mhy
Messages: 15
Registered: March 2001
Junior Member
dear sir,
I met a question, I want to made the records in one of my tables doubled every 5 minutes with a trigger?
eg.I have 5 recordes in a table named table1.the records in the table must be doubled in five minutes.
How can I do ?
THANX!

----------------------------------------------------------------------
Re: How can I to made the records in one of my tables doubled every 5 minutes with a trigger? [message #36003 is a reply to message #35996] Mon, 29 October 2001 21:34 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
Create a Procedure/trigger
Use the following command to insert the records
so that it will doubled the number of records .

insert into T select * from T ;

keep the procedure in job with interval 5 min

----------------------------------------------------------------------
Previous Topic: URGENT : Help needed for Stored procedures
Next Topic: How to calculate time ????? Urgent
Goto Forum:
  


Current Time: Thu Mar 28 09:39:53 CDT 2024