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 -> URGENT: Automate an update

URGENT: Automate an update

From: Kalle <kminerva_at_jippii.fi>
Date: Wed, 02 Jul 2003 08:52:06 GMT
Message-ID: <3F029BD5.BD43A1D@jippii.fi> 





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 - 03:52:06 CDT












Original text of this message













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