Home » SQL & PL/SQL » SQL & PL/SQL » DataBase Trigger wrt the SYSDATE
DataBase Trigger wrt the SYSDATE [message #36491] Thu, 29 November 2001 19:44 Go to next message
Sridhar J
Messages: 5
Registered: November 2001
Junior Member
Let me know how to Delete a table wrt the SYSDATE.

Basically the trigger should be based on the SYSDATE.
But the problem is, when the SYSDATE is getting changed in the DB SYSTEM,
the triggers should be excecuted,
i.e if the local value (DATE value ) inside the trigger is the 3rd day wrt
the SYSDATE then the trigger has to be executed.

Reply ASAP,

----------------------------------------------------------------------
Re: DataBase Trigger wrt the SYSDATE [message #36497 is a reply to message #36491] Fri, 30 November 2001 03:33 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
triggers are not right choice to do this, write procedure and schedule it using dbms_job package.

----------------------------------------------------------------------
Previous Topic: Raise _application_error
Next Topic: Re: Raise _application_error
Goto Forum:
  


Current Time: Thu Mar 28 12:25:25 CDT 2024