且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

在ddl创建脚本中抑制ORA-00942错误

更新时间:2023-01-31 15:48:36

If you get a script of drop statements, and Hibernate won't do it for you then wrap the DROP TABLE statements in an IF to test if the table exists before dropping it:

IF EXISTS(SELECT NULL 
            FROM TABLE_XYZ) THEN
  DROP TABLE TABLE_XYZ;
END IF;