Jobs in ORACLE

From: wolfgang karrer <wolfgang.karrer_at_ce.uni-linz.ac.at>
Date: Mon, 22 Nov 1999 19:21:50 +0100
Message-ID: <3839894d@alijku02.edvz.uni-linz.ac.at>

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 - 12:21:50 CST