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

Sounds funny. Do you want to start a procedure regularly on the first day of the month? Then use dbms_job package. There is no chance (and no sense) of firing a trigger on the first day of a month. When should this trigger fire? At 0:00 am or every second on this day or...
Otherwise, if you want to check the day in a trigger defined on a table you can do it with
...
if to_number(to_char(sysdate,'DD'))=1 then   do your trigger code
end if;

dj_brun_at_my-deja.com schrieb:

> 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.
Received on Mon Dec 13 1999 - 09:26:46 CST