Thursday, April 14, 2016

ORACLE Drop Table If Exists

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


Till Next Time

No comments: