Re: time triggered tasks in oracle

From: George Barbour <gbarbour_at_csc.com>
Date: Tue, 7 May 2002 12:13:30 +0100
Message-ID: <3cd7b6a7$1@pull.gecm.com>

Check out DBMS_JOB in the manuals.
BTW "ORDER" is not a clever name for an Oracle object, it is a reserved word in Oracle; and I think in ANSI.

George Barbour.

"Jens Aggergren" <jens_aggergren_at_hotmail.com> wrote in message news:8621ef5a.0205070217.3c60c850_at_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 - 06:13:30 CDT