Dropping all user tables/sequences in Oracle
BEGIN
--Bye Sequences!
FOR i IN(SELECT us.sequence_name
FROM USER_SEQUENCES us) LOOP
EXECUTE IMMEDIATE 'drop sequence '|| i.sequence_name ||'';
END LOOP;
--Bye Tables!
FOR i IN(SELECT ut.table_name
FROM USER_TABLES ut) LOOP
EXECUTE IMMEDIATE 'drop table '|| i.table_name ||' CASCADE CONSTRAINTS ';
END LOOP;
END;
--bye object
begin
FOR i IN(SELECT ut.object_name,ut.object_type
FROM user_objects ut where ut.object_type in ('PROCEDURE','PACKAGE','PACKAGE BODY','VIEW','FUNCTION') ) LOOP
EXECUTE IMMEDIATE 'drop '||i.object_type||' '|| i.object_name ;
END LOOP;
end;
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步