欢迎光临
我的个人博客

oracle删除指定用户名下所有sequence

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

转载请标明来源:ibear » oracle删除指定用户名下所有sequence

分享到:更多 ()

Where there is a will there is a way

BladeX企业级开发平台