zpusob 1

INSERT INTO OBJ_EMPLOYEES (employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct)
  SELECT employee_id, first_name, last_name, email, phone_number, hire_date, job_id, salary, commission_pct FROM EMPLOYEES;

INSERT INTO OBJ_DEPARTMENTS (department_id, department_name)
  SELECT department_id, department_name FROM DEPARTMENTS;

UPDATE OBJ_EMPLOYEES obj_emp
  SET obj_emp.manager_ref = -- nastavime referenci na managera pro kazdy zaznam v tabulce OBJ_EMPLOYEES
    (SELECT REF(obj_manager)  -- chceme referenci na objektoveho zamestnance
        FROM OBJ_EMPLOYEES obj_manager -- ovsem vazby zamestnanec->manager jsou podchyceny pouze v puvodnich relacnich tabulkach
        JOIN EMPLOYEES manager ON obj_manager.employee_id = manager.employee_id -- musime tedy dohledat odpovidajiciho relacniho managera
        JOIN EMPLOYEES emp ON emp.manager_id = manager.employee_id -- ktery je managerem "nejakeho" zamestnance emp
        WHERE emp.employee_id = obj_emp.employee_id -- ovsem konkretne prave toho zamestnance, kteremu prave referenci nastavujeme
        );

UPDATE OBJ_EMPLOYEES obj_emp
  SET obj_emp.department_ref = -- nastavime referenci na oddeleni pro kazdy zaznam v tabulce OBJ_EMPLOYEES
    (SELECT REF(obj_dept)  -- chceme referenci na objektove oddeleni
      FROM OBJ_DEPARTMENTS obj_dept -- ovsem vazby zamestnance->oddeleni jsou podchyceny pouze v puvodnich relacnich tabulkach
      JOIN DEPARTMENTS dept ON obj_dept.department_id = dept.department_id -- musime tedy dohledat odpovidajiciho relacni oddeleni
      JOIN EMPLOYEES emp ON emp.department_id = dept.department_id -- do ktere patri "nejaky" zamestnanec
      WHERE emp.employee_id = obj_emp.employee_id  -- ovsem konkretne prave ten zamestnanec, kteremu prave referenci nastavujeme
      );

UPDATE OBJ_DEPARTMENTS obj_dept
  SET obj_dept.manager_ref = -- nastavime referenci na oddeleni pro kazdy zaznam v tabulce OBJ_EMPLOYEES
    (SELECT REF(obj_manager) -- chceme referenci na objektoveho managera (zamestnance)
      FROM OBJ_EMPLOYEES obj_manager -- ovsem vazby oddeleni->manager jsou podchyceny pouze v puvodnich relacnich tabulkach
      JOIN EMPLOYEES manager ON obj_manager.employee_id = manager.employee_id -- musime tedy dohledat odpovidajiciho relacniho managera
      JOIN DEPARTMENTS dept ON dept.manager_id = manager.employee_id -- ktery je managerem "nejakeho" oddeleni
      WHERE dept.department_id = obj_dept.department_id -- ovsem konkretne prave toho oddeleni, ktermu prave referenci nastavujeme
      );