Update First Table Employee_id with 2nd Table Employee ID
SET TABLEOUTPUT ON DECLARE CURSOR CUR1 IS SELECT A.ID, A.EMPLOYEE_ID FROM TABLE2 A, WHERE A.EMPLOYEE_NAME= 'NEW'; COUNT_UP NUMBER; BEGIN BEGIN COUNT_UP := 0; FOR CUR2 IN CUR1 LOOP UPDATE TABLE1 SET EMPLOYEE_ID = CUR2.EMPLOYEE_ID WHERE ID = CUR2.ID; COUNT_UP := COUNT_UP + 1; END LOOP; EXCEPTION WHEN OTHERS THEN NULL; END; DBMS_OUTPUT.PUT_LINE('Record Update : '||COUNT_UP); END;
Comments
Post a Comment