update table from the values of other table

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

2

Contributors

1

Reply

8 Hours

Discussion Span

5 Months Ago

Last Updated

3

Views

nagarajuapex

Newbie Poster

2 posts since Jan 2013

Reputation Points: 0

Solved Threads: 0

Skill Endorsements: 0

5 Months Ago

0

Google does wonders: http://stackoverflow.com/questions/2446764/oracle-update-statement-with-inner-join

adam_k

Veteran Poster

1,057 posts since Jun 2011

Reputation Points: 274

Solved Threads: 205

Skill Endorsements: 11

update table from the values of other table

This article has been dead for over three months: Start a new discussion instead