Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

update table value based on the value from another table

Tony007May 10 2017 — edited May 10 2017

hi i have the following query i what to update the value of table based on the value in another table

this my use case

employeetable
empid   jobid
001       008
002       003
emp_job
emplid       em_jobid
001
002
update emp_job
set em_jobid = --jobid from employeetable
where emplid in('001','002')
This post has been answered by Saubhik Banerjee on May 10 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2017
Added on May 10 2017
4 comments
135 views