Home -> Usenet -> comp.databases.oracle -> PL/SQL trigger fires once a day

PL/SQL trigger fires once a day

From: Jagdip Singh Ajimal <jsa1981_at_hotmail.com>
Date: 8 Feb 2004 03:48:23 -0800
Message-ID: <c84eb1b0.0402080348.403d0328_at_posting.google.com> 






I am creating a table of appointments. As this table is going to get
very large very quickly, I want to move the old appointments into a
backup table, backupAppointments. How do I do this using a trigger? I
have got this so far:



create or replace trigger cleanAppointments
after insert on appointments


when apoointments.date < SYSDATE


Begin


-- move the records


End;



Any help would be greatly appriciated.
Received on Sun Feb 08 2004 - 12:48:23 CET












Original text of this message