Write a PL/SQL script to select details of employees who earn between Rs.3500 and 5500. Insert those records into tempemp table. Use record type declaration.

DECLARE
EMP_REC EMPS%ROWTYPE;

CURSOR C1 IS
SELECT * INTO EMP_REC FROM EMPS WHERE SALARY BETWEEN 3500 AND 5500;
BEGIN
OPEN C1;
LOOP
FETCH C1 INTO EMP_REC;
EXIT WHEN C1%NOTFOUND;
END LOOP;
INSERT INTO EMP_TEMPS
VALUES
(EMP_REC.EMPLOYEE_ID,EMP_REC.FIRST_NAME,EMP_REC.LAST_NAME,EMP_REC.EMAIL,EMP_REC.PHONE_NUMBER,EMP_REC.HIRE_DATE,EMP_REC.JOB_ID,EMP_REC.SALARY,EMP_REC.COMMISSION_PCT,EMP_REC.MANAGER_ID,EMP_REC.DEPARTMENT_ID);
END;
/