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: 21123
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: Wed Jun 28 19:35:28 CDT 2017

Total time taken to generate the page: 0.21614 seconds