MERGE INTO T_AGENCY A
USING T_AGENCY_TEMP B
ON (A.AGENCYCODE = B.AGENCYCODE)
WHEN MATCHED THEN
UPDATE SET A.MAPLON = B.LON, A.MAPLAT = B.LAT, A.MAPLEVEL = 13 WHERE A.MAPLON='116.370968'
DELETE FROM A.ISDELETED=1;
请好好体味这个语句!
MERGE INTO T_AGENCY A
USING T_AGENCY_TEMP B
ON (A.AGENCYCODE = B.AGENCYCODE)
WHEN MATCHED THEN
UPDATE SET A.MAPLON = B.LON, A.MAPLAT = B.LAT, A.MAPLEVEL = 13 WHERE A.MAPLON='116.370968'
DELETE FROM A.ISDELETED=1;