From table "temp" fetch records to table "emp" which has some records using a cursor in PL/SQL language.urgent

Question

From a table called "temp" we have to fetch records to table "emp" such that e_id starts from the next value of the maximum e_id in table "emp" but all the remaining fields should be fetched from table"temp" using a cursor in PL/SQL language

Answer 1

how about something like this?

CREATE OR REPLACE PROCEDURE proc
v_eid emp.eid%TYPE;
CURSOR c1 IS
SELECT t.*
FROM temp t;
c1r c1%ROWTYPE;
BEGIN
select max(e_id) into v_eid from emp;
FOR c1r IN c1 LOOP
v_eid := v_eid+1;
insert into emp values (v_eid, put here all the required values
in the form c1r.tempcol)
END LOOP;
END;

I'm not sure of all the syntax but it is pretty close.