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...
nagarajuapex 0 Newbie Poster
adam_k 239 Master Poster
Google does wonders: http://stackoverflow.com/questions/2446764/oracle-update-statement-with-inner-join
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.