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