Re: Automate an update

Hi,

If you are looking to populate this table with the y/n value based on the time, you could just create a job (oracle/cron) to update the table with the appropriate value when the time changes over. That would be the simplest way, but maybee not the cleanest.

HTH, Joe

--
Joe Frohne
Rawson Oaks Consulting,
Remote Oracle Administration
http://www.rawsonoaks.com
[EMAIL PROTECTED] or [EMAIL PROTECTED]



> 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,

>

> Joshua

>

> Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joe Frohne
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).