DELETE TABLE DATA USING CURSOR

create or replace PROCEDURE EMPMAST.DELETE1_DATA_From_INDIA_EMP
 AS
 v_city INDIA_EMP.CITY%TYPE;
 CURSOR del_cursor1 IS SELECT DistrictName INTo v_city
                                           FROM ( select DistrictName
                                                         from    EMPMAST.DISTRICT_MASTER
                                                         ORDER BY dbms_random.value ) WHERE rownum = 1;
BEGIN
 OPEN del_cursor1;
 LOOP
 FETCH del_cursor1 into v_city;
 EXIT WHEN del_cursor1%NOTFOUND;
 DELETE from EMPMAST.INDIA_EMP;
 COMMIT;
 END LOOP;
 dbms_output.put_line('TOTLA '||sql%rowcount||' Deleted');
 CLOSE del_cursor1;
 end DELETE1_DATA_From_INDIA_EMP;
 /


 DELETE FROM EMPMAST.INDIA_EMP WHERE CITY=(select DistrictName from    EMPMAST.DISTRICT_MASTER ORDER BY dbms_random.value ) WHERE rownum = 1);