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; /
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter