time triggered tasks in oracle

From: Jens Aggergren <jens_aggergren_at_hotmail.com>
Date: 7 May 2002 03:17:51 -0700
Message-ID: <8621ef5a.0205070217.3c60c850@posting.google.com>

Can anyone tell me if it is possible to define events triggered by date/time?

ex: In an order management database a new order is entered.

    the order table i defined like this:

CREATE TABLE ORDER(

NR 		INTEGER NOT NULL,
STATUS 		CHAR DEFAULT( 'A' ),
DATO 		DATE,
BUTIKSNR 	INTEGER NOT NULL,

PRIMARY KEY( NR ),
UNIQUE( NR ),
FOREIGN KEY( BUTIKSNR ) REFERENCES BUTIK(NR), CONSTRAINT STATUS_TYPE CHECK ( STATUS IN ( 'A', 'B', 'C' )));     8 days later the status must be set to 'b'.

can it be done? Received on Tue May 07 2002 - 05:17:51 CDT