CURSOR EXAMPLE IN ORACLE

AS SALAMO ALAIKUM WA RAHMATULLAH


DECLARE 
CURSOR C1 IS SELECT * FROM XXX_EMP_STG;
BEGIN
FOR I IN C1
LOOP
    BEGIN
        -- FIRST CHECK THE EMPNO
        IF(I.EMPNO) IS NULL THEN
        E_FLAG:='E';
        E_MSG:='EMPNO IS NOT VALID';
        END IF;
    END;
END LOOP;
END;



--
MA ASALAAM
PASSION FOR ORACLE