Oracle删除用户下的sequence

来源:互联网 发布:c语言头文件大全 编辑:程序博客网 时间:2024/06/06 08:35

--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;  


原创粉丝点击