Re: Daily SQL Update Statement Execution

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 15 Mar 2000 14:38:58 +0100
Message-ID: <953143443.8022.0.pluto.d4ee154e@news.demon.nl>

write a pl/sql procedure with the update statement and submit this through the dbms_job package.

Hth,

Sybrand Bakker, Oracle DBA

Marty Provost <mprovost_at_liquidgolf.com> wrote in message news:v4Mz4.1256$kv6.71320_at_newsread1.prod.itd.earthlink.net...
> I need to run an update sql statement once a day. How can I automate
this?
> I am familiar with how to schedule an OS command file/batch file but I
don't
> know how to make a sql statement an OS executable file.
>
> On the flip side, I looked at making a trigger but I don't know how to
> schedule the trigger to run daily, not based on another sql statement.
>
> Thanks in advance for you help.
>
> Marty
>
>
Received on Wed Mar 15 2000 - 07:38:58 CST