CREATE TABLE empc ( emp_id NUMBER PRIMARY KEY, name VARCHAR2(100), hire_date DATE -- other columns ); DECLARE CURSOR emp_cursor IS SELECT empno, ename, hiredate FROM employee WHERE (SYSDATE - hiredate) / 365.25 >= 23; -- Calculate experience in years emp_record emp_cursor%ROWTYPE; BEGIN OPEN emp_cursor; LOOP FETCH emp_cursor INTO emp_record; EXIT WHEN emp_cursor%NOTFOUND; INSERT INTO empc (emp_id, name, hire_date) VALUES (emp_record.empno, emp_record.ename, emp_record.hiredate); END LOOP; CLOSE emp_cursor; COMMIT; END; /