| how to update a table automatically [message #369934] |
Wed, 08 November 2000 04:47 |
Amol Sonaikar
Messages: 1
Registered: November 2000
|
Junior Member |
|
|
I Have a table in which I am storing a two columns
'Start_date and 'End_date' where 'start_date' is entered as greater than sysdate and end_date greater than start date. Also I have Start_Time which is again a date field.
There is another column in same table called 'Status'
This column's value should be modified to 'open' at
the specified 'Start_Date' and on that 'Start_Time'
By the system itself. This currently done manually on
SQL prompt by me. Is there any method or procedure or
package which will automatically update the record to 'open' when specified time or date is reached
Amol
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
