troubleshooting Question

How to schedule a oracle job to update a column using information provided in a view.

Avatar of TECH_NET
TECH_NET asked on
Oracle DatabaseMicrosoft SQL Server 2005
8 Comments1 Solution1414 ViewsLast Modified:
I have a table with hold information of employees who left 6 months ago. Now i wish to update the leave dates of these employees with information provided in another table.

ie the SOURCE table is EMPLOYEE_STAGING ( which hold the employee who left 6 months back)
EMPLOYEE_CREDENTIALS table( hold the current info)
here is what i need to perform

UPDATE EMPLOYEE_STAGING  ES
SET  LEAVE_DATE= (SELECT LEAVE_DATE FROM EMPLOYEE_CREDENTIALS  EC WHERE EC.EMP_ID=ES.EMP_ID)
WHERE EC.EMP_ID=ES.EMP_ID

I hope i am able to convey what i am trying to accomplish using the above code although it might be totaling wrong.

I also want to have this job of updating schedueld on a weekly basis.

How can i do so?


ASKER CERTIFIED SOLUTION
Jinesh Kamdar

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros