删除数据: SELECT 'DELETE FROM '|| table_name || ';' FROM USER_TABLES ORDER BY TABLE_NAME; 删除表: select 'drop table '||table_name||';' from cat where table_type='TABLE'