DROP TABLE - NOT EXIST

BEGIN
   EXECUTE IMMEDIATE 'DROP TABLE XX';
EXCEPTION
   WHEN OTHERS THEN
      IF SQLCODE != -942 THEN
         RAISE;
      END IF;
END;
/
COMMIT;

 

posted @ 2020-05-07 10:03  kakaisgood  阅读(294)  评论(0)    收藏  举报