kurs:merge_werte_einfuegen
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
kurs:merge_werte_einfuegen [2014/09/10 21:22] 127.0.0.1 external edit |
kurs:merge_werte_einfuegen [2014/10/14 15:38] 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, | ||
| + | 10001 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> | <code> | ||
| merge into emp_copy c | merge into emp_copy c | ||
kurs/merge_werte_einfuegen.txt ยท Last modified: 2014/10/14 15:38 by mh
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
