Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MERGE INTO fp_pl_points_link d
- USING (SELECT 1 point_id, 2 link_point_id, 3 delay_count, 4 delay_period_ident
- FROM dual
- union all
- SELECT 1 point_id, 2 link_point_id, 3 delay_count, 4 delay_period_ident
- FROM dual
- union all
- SELECT 1 point_id, 2 link_point_id, 3 delay_count, 4 delay_period_ident
- FROM dual
- ) o
- ON (d.point_id = o.point_id)
- WHEN MATCHED THEN
- UPDATE SET d.link_point_id = o.link_point_id, d.delay_count = o.delay_count, d.delay_period_ident = o.delay_period_ident
- WHEN NOT MATCHED THEN
- INSERT (d.point_id,d.link_point_id, d.delay_count, d.delay_period_ident)
- VALUES (o.point_id,o.link_point_id, o.delay_count, o.delay_period_ident);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement