set serveroutput on
DECLARE
  v_sqlstatement varchar2(100);
  v_deletegroup deletegroup%rowtype;
  CURSOR deletegroup_cursor IS
    SELECT * from deletegroup;
BEGIN
  DBMS_OUTPUT.PUT_LINE ('****************** begin account deletion');
  OPEN deletegroup_cursor;
  FETCH deletegroup_cursor into v_deletegroup;
  WHILE deletegroup_cursor%found LOOP

     DBMS_OUTPUT.PUT_LINE (v_deletegroup.userid); 
     v_sqlstatement := 'drop user "' || v_deletegroup.userid || '" cascade';
     execute immediate v_sqlstatement;

     FETCH deletegroup_cursor into v_deletegroup;
  END LOOP;
  DBMS_OUTPUT.PUT_LINE ('****************** end account deletion');
  CLOSE deletegroup_cursor;
END;
/