【Oracle】批量删除表

最新推荐文章于 2024-08-07 17:22:15 发布

jinhuazhe2013

最新推荐文章于 2024-08-07 17:22:15 发布

阅读量5.4k

点赞数 1

分类专栏： Oracle 文章标签： oracle

本文链接：https://blog.csdn.net/u012386311/article/details/53583287

版权

Oracle 专栏收录该内容

12 篇文章 0 订阅

订阅专栏

sql

SET SERVEROUTPUT ON;

DECLARE
LNAME VARCHAR2(200);
BEGIN
FOR X IN (select TABLE_NAME from user_tables
where table_name like 'SYMPHONY%'
) LOOP
LNAME:= X.TABLE_NAME;
EXECUTE IMMEDIATE 'DROP TABLE '|| X.TABLE_NAME ;
END LOOP;
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.put_line(LNAME);
RAISE;
END;
/

执行结果

SQL> SET SERVEROUTPUT ON;
SQL> DECLARE
  2  LNAME VARCHAR2(200);
  3  BEGIN
  4  FOR X IN (select TABLE_NAME from user_tables
  5  where table_name like 'SYMPHONY%'
  6  ) LOOP
  7  LNAME:= X.TABLE_NAME;
  8  EXECUTE IMMEDIATE 'DROP TABLE '|| X.TABLE_NAME ;
  9  END LOOP;
 10  EXCEPTION
 11  WHEN OTHERS THEN
 12  DBMS_OUTPUT.put_line(LNAME);
 13  RAISE;
 14  END;
 15  /


PL/SQL procedure successfully completed