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