Differences

This shows you the differences between two versions of the page.

--- kurs:merge_werte_einfuegen [2010/10/30 11:31]
mh
+++ kurs:merge_werte_einfuegen [2014/10/14 15:38] (current)
mh
@@ Line 1: / Line 1: @@
+<code>
+merge into emp_merge m
+using
+(select  1 employee_id, -- sequence not allowed here
+        'Hofstetter' last_name,
+        'IT_PROG' job_id,
+salary,
+        sysdate hire_date
+        from dual) e
+on (m.last_name = e.last_name)
+when matched then
+  update set salary = e.salary
+when not matched then
+insert (
+  employee_id,
+  last_name,
+  job_id,
+  salary,
+  hire_date
+  ) values (
+  seq.nextval,
+  e.last_name,
+  e.job_id,
+  e.salary,
+  e.hire_date
+  )
+</code>
 <code>
 merge into emp_copy c

dokuwiki