1,105,208 Community Members

update table from the values of other table

Member Avatar
nagarajuapex
Newbie Poster
2 posts since Jan 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

How can we update one table with the values of other table in oracle.
i have entity table with entityid and entityname
and template table with templateid and templatesk
sofar entityid is getting values from templatesk but now
it should get from templateid .how can we do this..
update statement doesnt support join...

Member Avatar
adam_k
Veteran Poster
1,056 posts since Jun 2011
Reputation Points: 239 [?]
Q&As Helped to Solve: 212 [?]
Skill Endorsements: 17 [?]
 
0
 
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article