Oracle删除用户下的sequence

--Oracle删除用户下的sequence

 declare owner_name varchar(20);  
    cursor cur1 is select sequence_name from user_sequences;  
    begin  
        owner_name := '用户名';   
        for cur2 in cur1 loop  
            execute immediate 'drop sequence '||owner_name||'.'||cur2.sequence_name;  
        end loop;  
    end;