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)
Posts
return code before grep
-
my 2009 solution return code before grep ( ( ( mycmd echo $? >&3 ) |grep
mytext >&4 ) 3>&1 |(read x;exit $x) )4>&1 my 2025 solution mycmd > >(grep
mytext)
2 weeks ago
3 comments:
Maaza nahi aaya...
Not a gaurav like query.
Maaza nahi aaya...
Not a gaurav like query.
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
Post a Comment