Jobs in ORACLE

Article View: comp.databases.oracle.misc

Article #118

Back to comp.databases.oracle.misc Previous Next

#118

From: wolfgang karrer
Date: Mon, 22 Nov 1999 00:00

35 lines
1652 bytes

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@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@ce.uni-linz.ac.at

Technical Details

Message-ID: <3839894d@alijku02.edvz.uni-linz.ac.at>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: fb53f,fa9cc94c253c0626,start
X-Google-Attributes: gidfb53f,public
X-Google-Thread: fa4f9,fa9cc94c253c0626,start
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f99a8,fa9cc94c253c0626,start
X-Google-Attributes: gidf99a8,public
From: "wolfgang karrer" <wolfgang.karrer@ce.uni-linz.ac.at>
Subject: Jobs in ORACLE
Date: 1999/11/22
Message-ID: <3839894d@alijku02.edvz.uni-linz.ac.at>
X-Deja-AN: 551721989
X-Trace: 22 Nov 1999 19:19:57 +0100, karrer.ce.uni-linz.ac.at
Organization: Johannes Kepler Universitaet Linz
X-MSMail-Priority: Normal
X-Priority: 3
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,hannover.uni.comp.oracle
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300