Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Jobs in ORACLE
Hi
you can run a scheduled job depending on the
operating sistem (cron or at ) so that it
checks the database every day and if
finds the release date = system date
then update the released column.
like
if release date <= sysdate and released = 'N' then
update released = 'Y' where condition matches.
HTH
pradhan
wolfgang karrer wrote:
> Hi, i ve a Question concerning Jobs in ORACLE:
>
> How is it possible to control a date column by the database if the sysdate
> is equal to the date: Example
>
> I ve a table like
>
> SLIDE
> name VARCHAR2(10),
> abstract VARCHAR(500);
> relDate DATE
> released CHAR (1)
>
> if the actual date (sysdate) is equal to the relDate in the table SLIDE i
> want to update the released col in 'N'. How is this possible???
>
> Thanks in advance for helping me!!
>
> --
> Wolfgang Karrer
> Büro für EDV-Dienstleistungen
> Gewerbegasse 6
> 4060 Leonding
> Tel + Fax. (0732) 681795
> Mobil: (0699) 134 18 469
> EMail: w.karrer_at_ooenet.at
> ---------------------------------------
> Institut für Wirtschaftsinformatik
> Abteilung Communications Engineering
> o.Univ.- Prof. DI Dr. Christian Stary
> Freistädterstr. 315
> 4040 Linz/Urfahr
> Tel: (0732) 2468-7104
> EMail: wolfgang.karrer_at_ce.uni-linz.ac.at
Received on Mon Nov 22 1999 - 17:12:11 CST