RE: Automate an update

From: Pardee, Roy E <roy.e.pardee_at_lmco.com>
Date: Wed, 02 Jul 2003 09:44:44 -0700
Message-ID: <F001.005BEE9B.20030702092539@fatcity.com>

Do window_open's values depend on the time the record is inserted, or the time it is retrieved? If the former, you could do it in a trigger. If the latter, you could make window_open a calculated column in a view.

What are you using for a user interface--oracle forms, sql*plus, java, vb...?

HTH,
-Roy

Roy Pardee
Programmer/Analyst/DBA
SWFPAC Lockheed Martin IT
Extension 8487
-----Original Message-----

Sent: Wednesday, July 02, 2003 2:41 AM
To: Multiple recipients of list ORACLE-L

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: Pardee, Roy E
  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). Received on Wed Jul 02 2003 - 11:44:44 CDT