469,331 Members | 1,901 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

trigger a particular date

kiss07
99
Hi,

I want to create a trigger in my applications.
my recruitment is following:

In a table emp every month particular(example 5th of every month) date is execute a trigger.

How can i do it. Am a new person in trigger concepts.pls coding ..


Thanks,

Arun..
May 3 '07 #1
1 1234
debasisdas
8,127 Expert 4TB
First of all u can't execute a trigger.

Trigger fires automatically when the concerned event(insert,update,delete) on which the trigger is based executes .

U can execute that command in a procedure and next go for job scheduling using

DBMS_JOBS----------upto 9i
or
DBMS_SCHEDULER-------------in 10g (DBMS_JOBS not available)

these are predefined packages.
May 3 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by Anton.Nikiforov | last post: by
reply views Thread by JohnO | last post: by
2 posts views Thread by James Foreman | last post: by
3 posts views Thread by Barbara Lindsey | last post: by
reply views Thread by lalala | last post: by
3 posts views Thread by lenygold via DBMonster.com | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Purva khokhar | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.