Re: How can I create a trigger that depends on system date?

In article <832kjs$uv0$1_at_nnrp1.deja.com>,   dj_brun_at_my-deja.com wrote:
> I donīt know if there's any way to create a
> trigger that depends on system date. I want
> Oracle to fire the trigger when the day of the
> current system date= 1. If someone could tell
> me...
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sounds like what you're looking to do is run a batch job? you can submit procedures/packages to run on a particular day or even daily - check if the date is 1 and end if it's not. See dbms_job procedures.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 06:48:36 CST