Oracle删除当前用户下的所有表或数据

            create
            or
            replace
            procedure pro_droptable iscursor cur isselect table_name from user_tables;
drop_sql varchar2(1000);
beginfor tbname in cur loop
    begin
      drop_sql:=‘drop table ‘||tbname.table_name;--将drop修改为truncate即可删除所有表的数据execute immediate drop_sql;
    end;
  end loop;
end pro_droptable;