Junior Member
Posts: 97
Joined: Jul 2004
|
This is quite difficult for me to explain and lenghty.
I have 2 table where I need to update the records for individuals based on their department.
Tables:
TT_HISTORY.ID
TT_HISTORY.STARTTIME
TT_HISTORY.ENDTIME
TT_HISTORY.STATUS_ID
TT_Current.EMPLOYEE_ID
TT_Current.STATUS_ID
CS_Employee.Employee_ID
CS_Employee.Name
CS_Employee.Department_Code
CS_Employee.Manager_ID
Basically, at 11:59pm, I want all employees that have a STATUS_ID = 0 changed to 5 with the current time for all employees that are in department 9812.
I hope this makes sense. Can someone help me out? I can do it in ACCESS, but I do not know how in oracle and this is where my data is housed.
|
cdbymike
08-08-2004 @ 11:07 PM
