Re: How to implement time-based trigger in Oracle8 database?

From: Ulrik Hoffmann <ulrik_at_hoffmann-kiel.de>
Date: Fri, 23 Jul 1999 07:49:44 +0100
Message-ID: <7n8vqo$lk4$1@freeside.cls.net>

Hi,

write a stored procedure and use the dbms_job package to execute the procedure at a specified time.

Bye
Uli

<dejasg_at_my-deja.com> schrieb in im Newsbeitrag: 7n8kea$bnu$1_at_nnrp1.deja.com...
> Hi,
>
> I will appreciate it if you can tell me how can I have a
> trigger process that is activated at regular time interval (let say
> every day at midnight) to do some checking and updating to tables in
> Oracle8 database. Do I use database triggers or does Oracle8 provides
> other ways in achieving similar job process?
>
> Thank you.
>
> Cheers,
> Koot Sung
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jul 23 1999 - 01:49:44 CDT