OraFAQ Forum: SQL & PL/SQL » How can I to made the records in one of my tables doubled every 5 minutes with a trigger?

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?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

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!

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

Report message to a moderator

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

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

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 14:53:10 CST 2024