?MERGE INTO trackedVehicleBus t
? ? USING (SELECT tt.* FROM trackedVehicleBus tt WHERE tt.tracktype = 2) tw
? ? ON (t.tracktype = tw.tracktype)
? ? WHEN MATCHED THEN
? ? ? UPDATE SET t.rolename = 'upad3te'
? ? WHEN NOT MATCHED THEN
? ? ? INSERT
? ? ? VALUES
? ? ? ? ('11', '22', 'insert', 'a$f$fG$ff', 1, '02:00', '05:00', 2);
? ??
? ? MERGE INTO trackedVehicleBus t
? ? USING (select count(*) co
? ? ? ? ? ? ?from trackedVehicleBus bs
? ? ? ? ? ? where bs.tracktype = 2) tw
? ? ON (tw.co <> 0)
? ? WHEN MATCHED THEN
? ? ? UPDATE SET t.rolename = 'upad3te'
? ? WHEN NOT MATCHED THEN
? ? ? INSERT
? ? ? VALUES
? ? ? ? ('11', '22', 'insert', 'a$f$fG$ff', 1, '02:00', '05:00', 2);
? ??
