oracle删除当前用户的表

分类: IT文章 • 2024-05-13 17:58:00

删除用户的表：

declare 
  table_name varchar(100);
  drop_sql varchar(100);
cursor c1 is select table_name from user_tables;
begin
  open c1;
  loop
    fetch c1 into table_name;
     drop_sql:='drop table '||table_name;
    execute immediate drop_sql;
    dbms_output.put_line(table_name);
    exit when c1%NOTFOUND;
  end loop;
  close c1;
end;

oracle删除当前用户的表

相关推荐