Advertisement
ZUKMAN

Untitled

Oct 23rd, 2014
148
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. MERGE INTO fp_pl_points_link d
  2. USING (SELECT 1 point_id, 2 link_point_id, 3 delay_count, 4 delay_period_ident
  3. FROM dual
  4. union all
  5. SELECT 1 point_id, 2 link_point_id, 3 delay_count, 4 delay_period_ident
  6. FROM dual
  7. union all
  8. SELECT 1 point_id, 2 link_point_id, 3 delay_count, 4 delay_period_ident
  9. FROM dual
  10. ) o
  11. ON (d.point_id = o.point_id)
  12. WHEN MATCHED THEN
  13. UPDATE SET d.link_point_id = o.link_point_id, d.delay_count = o.delay_count, d.delay_period_ident = o.delay_period_ident
  14. WHEN NOT MATCHED THEN
  15. INSERT (d.point_id,d.link_point_id, d.delay_count, d.delay_period_ident)
  16. 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