Differences

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

--- kurs:insert [2014/09/10 21:22]
+++ kurs:insert [2014/09/10 21:22] (current)
@@ Line 1: / Line 1: @@
+<code>
+insert into emp_copy (
+   employee_id,
+   first_name,
+   last_name,
+   email,
+   hire_date,
+   job_id,
+   department_id
+  ) values (
+   employees_seq.nextval,
+   'Mark',
+   'Hofstetter',
+   'joeh',
+   sysdate,
+   'IT_PROG',
+   (select department_id from departments where department_name = 'IT' )
+   );
+insert into emp_copy (
+   employee_id,
+   first_name,
+   last_name,
+   email,
+   hire_date,
+   job_id,
+   department_id
+  )
+  select
+   employees_seq.nextval,
+   first_name,
+   last_name,
+   email,
+   sysdate,
+   job_id,
+   d.department_id
+   from departments d, employees e where department_name = 'IT'
+     and e.department_id = d.department_id
+   ;
+select employees_seq.currval from dual;
+ select * from emp_copy where rownum =1  order by employee_id DESC
+</code>

dokuwiki