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
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
Messages: 20849
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: Fri Oct 21 17:55:57 CDT 2016

Total time taken to generate the page: 0.17560 seconds