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)
sqlite3
-
I just tried sqlite. It is ultra-light and support SQL commands. Just try
this $ sqlite3 test.db SQLite version 3.26.0 2018-12-01 12:34:55 Enter
".help" fo...
4 days ago