declare begin for i in (select table_name from dba_tables where owner=:username) loop execute immediate 'drop table '||:username||'.'||i.tablename; end loop; end;本回答被提问者和网友采纳
第2个回答 2009-11-25
spool drop_tables.sql select || 'drop table '||table_name||';' from user_tables; spool off @drop_tables.sql