troubleshooting Question

Update multiple records with condition

Avatar of hearnp
hearnp asked on
Oracle Database
4 Comments1 Solution858 ViewsLast Modified:
In my script I am trying to update my table office_employee with new translated job titles.
Inf French the translation of job titles can be different for males and females.  There fore I need to have
my script update the office_employee table based upon the gender column in another table employee.
When I run the script below I get get no results.   The condition should be:  change the french Job_title to xxxx where the emp_id matches the emp_id in the  employee table and then only update the fr_job_title with the apprpate translation based upon gender.

UPDATE OFFICE_EMPLOYEE
SET FR_JOB_TITLE = 'xxxx'
WHERE JOB_TITLE = 'Senior Business Solutions Adviser' AND
OFFICE_EMPLOYEE.EMP_ID = EMPLOYEE.EMP_ID AND
EMPLOYEE.GENDER = 'M'


 
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
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 4 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