Home » SQL & PL/SQL » SQL & PL/SQL » Timer
Timer [message #390157] Thu, 05 March 2009 04:33 Go to next message
handala
Messages: 5
Registered: February 2009
Location: Palestine
Junior Member

Hey All,

I like to ask about Timer,

I wanna add a timer on a table, every few seconds the new data will be inserted into another table.

is there a trigger or smth???

thanks
Re: Timer [message #390160 is a reply to message #390157] Thu, 05 March 2009 04:57 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You want to look at DBMS_JOB or DBMS_SCHEDULER
Re: Timer [message #390165 is a reply to message #390157] Thu, 05 March 2009 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or just execute a PL/SQL block with a dbms_lock.sleep call between each loop.

Regards
Michel
Re: Timer [message #390209 is a reply to message #390157] Thu, 05 March 2009 07:51 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
handala wrote on Thu, 05 March 2009 05:33

is there a trigger or smth???



I doubt very much that it is smth.
Re: Timer [message #390215 is a reply to message #390209] Thu, 05 March 2009 08:31 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
joy_division wrote on Thu, 05 March 2009 13:51
handala wrote on Thu, 05 March 2009 05:33

is there a trigger or smth???



I doubt very much that it is smth.


Well, I read the term smth and I assumed that the op meant Smith a common generic name, Also a name commonly used when one wishes to maintain their anonymity. Anonymity leads us to Anonymous blocks so obviously the OP was asking us if there was a way of achieving the required results via an anonymous block
See, just simple logic Smile
Re: Timer [message #390216 is a reply to message #390157] Thu, 05 March 2009 08:43 Go to previous messageGo to next message
cookiemonster
Messages: 12403
Registered: September 2008
Location: Rainy Manchester
Senior Member
I thought he was talking about Agent Smith from the matrix and was looking for an AI to solve his problem
Razz
Re: Timer [message #390265 is a reply to message #390216] Thu, 05 March 2009 12:13 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If I remember well, once upon a time there was a movie named "Electric Dreams". A character spilled champagne over Apple Macintosh II and created artificial intelligence.

After watching the film, someone came home and wanted to do the same. Though, he had ZX Spectrum (much cheaper than Mac) so - in order to maintain the ratio - he chose Coca Cola and spilled it all over Spectrum.

Did he create AI? Not really, but he had proved that both human stupidity and the universe are infinite (some restrictions apply) ./fa/5851/0/
icon13.gif  Re: Timer [message #390293 is a reply to message #390265] Thu, 05 March 2009 14:38 Go to previous messageGo to next message
handala
Messages: 5
Registered: February 2009
Location: Palestine
Junior Member

Thanks to all,

U help alot !!!!!!!!!!!!!!!!!!!!!!!

Re: Timer [message #390294 is a reply to message #390293] Thu, 05 March 2009 14:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't see any answer from U, so how did he help?

Regards
Michel
Re: Timer [message #390295 is a reply to message #390293] Thu, 05 March 2009 14:46 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
I will tell "U" when I see him.

I think that will be at a party with "Q" this weekend, where we will hang out with "M"
Re: Timer [message #390296 is a reply to message #390295] Thu, 05 March 2009 15:10 Go to previous message
handala
Messages: 5
Registered: February 2009
Location: Palestine
Junior Member

please don't forget "a,b,c,d,e,f,g,h ......... )
Previous Topic: Populate a table with multiple records
Next Topic: Confused need a query (Merged)
Goto Forum:
  


Current Time: Sun Dec 04 16:49:06 CST 2016

Total time taken to generate the page: 0.10214 seconds