Google
Information Storage and Retrieval: Updation of a table by the values from a different table

Pages

Thursday, November 12, 2009

Updation of a table by the values from a different table

Scenario: There are 2 oracle tables TEST1 and TEST2 containing 2 columns each : EMP_ID and EMAIL_ID. How will you update column EMAIL_ID of table TEST1 with the values of EMAIL_ID of table TEST2. The join condition to be used will be on EMP_ID.

Solution:

update test1 set test1.email_id = (select test2.email_id from test2 where test1.emp_id=test2.emp_id)
where
exists (select 1 from test2 where test1.emp_id=test2.emp_id)

3 comments:

Kartik said...

Maaza nahi aaya...
Not a gaurav like query.

Kartik said...

Maaza nahi aaya...
Not a gaurav like query.

James Zicrov said...

Thank you so much for providing and enlightening more aspects of Informatica that help in avoiding it getting damaged and becoming useless.

Informatica Read JSON