Re: Trigger question

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?

>

>