begin for c1 in (select t.table_name from user_tables t) loop execute immediate 'drop table ' || c1.table_name || ' cascade constraints'; end loop; end; 这个可以把你用户下所有表都删除哈!!小心使用哦!
改造了下,谢谢!create or replace procedure pro_delete as begin for c1 in (SELECT table_name FROM ALL_TABLES WHERE OWNER = UPPER('user_name') AND (TABLE_NAME = UPPER('test1') or TABLE_NAME = UPPER('test2'))) loop execute immediate 'drop table ' || c1.table_name || ' cascade constraints'; end loop; end;
for c1 in (select t.table_name from user_tables t) loop
execute immediate 'drop table ' || c1.table_name ||
' cascade constraints';
end loop;
end;
这个可以把你用户下所有表都删除哈!!小心使用哦!
改造了下,谢谢!create or replace procedure pro_delete
as
begin
for c1 in
(SELECT table_name FROM ALL_TABLES
WHERE OWNER = UPPER('user_name')
AND (TABLE_NAME = UPPER('test1') or TABLE_NAME = UPPER('test2'))) loop
execute immediate 'drop table ' || c1.table_name || ' cascade constraints';
end loop;
end;
drop table 表1;
drop table 表2
就OK!