Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: Automate an update

Re: URGENT: Automate an update

From: Abhijith <abhijith_at_nomail.com>
Date: Wed, 02 Jul 2003 15:19:40 +0530
Message-ID: <3F02AAB4.6020403@nomail.com>


write an on update trigger

Kalle wrote:
> Hi all,
>
> I need help in order to create a following "mechanism".
>
> I have a table where is a column called window_open and it has two
> values 'Y' and 'N'
>
> Now I need to automate the update a single row based on following rules:
>
> If time is between 08:00-16:00 the value on that window_open column
> should be 'Y' during other period the value should be 'N'. How can I do
> this and automate the task...
>
> Thanks in advance,
>
>
Received on Wed Jul 02 2003 - 04:49:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US