From joe@rawsonoaks.com Wed, 02 Jul 2003 08:38:33 -0700 From: "Joe Frohne" Date: Wed, 02 Jul 2003 08:38:33 -0700 Subject: Re: Automate an update Message-ID: MIME-Version: 1.0 Content-Type: text/plain 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).