From: "Jonathan Lewis" Subject: Re: Trigger question Date: 2000/06/06 Message-ID: <960320220.10430.2.nnrp-06.9e984b29@news.demon.co.uk>#1/1 X-NNTP-Posting-Host: jlcomp.demon.co.uk:158.152.75.41 References: X-Trace: news.demon.co.uk 960320220 nnrp-06:10430 NO-IDENT jlcomp.demon.co.uk:158.152.75.41 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Newsgroups: comp.databases.oracle.misc X-Complaints-To: abuse@demon.net Just a thought to play with, why do you even need the status field ? create view ... as ... decode(sign(trunc(sysdate)-date_field,-1,'Open','Closed')) status_field -- Jonathan Lewis Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk Rookie wrote in message ... >I would like to update a status field from open to close when the >corresponding date field reaches today's date. > >Should I just run a batch routine every night, or can I schedule Oracle 8i >to handle this for me automatically every night? > >