Home » SQL & PL/SQL » SQL & PL/SQL » On Date Change Trigger
icon2.gif  On Date Change Trigger [message #221258] Mon, 26 February 2007 00:42 Go to next message
myclassic
Messages: 127
Registered: December 2006
Location: Pakistan
Senior Member
Dear All

I want to write a trigger on a Table which will be populated on Date Change. what will be the syntax.

e.g. I have a table ABC having columns(RollNumber , Name, Fee)
and I want to copy these column in a table XYZ( having same Columns listed above, on every day on date change.

plz guide me.
take care.
Re: On Date Change Trigger [message #221299 is a reply to message #221258] Mon, 26 February 2007 03:48 Go to previous message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As I've understood it, it is not a trigger you need, but a JOB, scheduled to run at 24:00 hours every day. Search for DBMS_JOB or DBMS_SCHEDULER examples.
Previous Topic: Regarding DECODE
Next Topic: i want basic query
Goto Forum:
  


Current Time: Tue Dec 06 02:25:53 CST 2016

Total time taken to generate the page: 0.15657 seconds