dept表和locations表的结构如下: dept表: Name Null? Type dept_id number(4) dept_name not null varchar2(30) manager_id nubmer(6) location_id number(4) city varchar2(30) locations表: Name Null? Type location_id not null number(4) address varchar2(20) postal_code varchar2(12) city not null number(4) state varchar2(25) country_id char(2) 将dept表中每行的city的值修改为locations表中相应的city的值,正确的语句为:
A.
update dept set city=any(select city from locations)
B.
update dept set city=(select city from locations) where dept.location_id=locations.location_id
C.
update dept set city=(select city from locations where dept.location_id=locations.location_id)
D.
update dept set city=all(select city from locations) where dept.location_id=locations.location_id