dcsimg
 

Oracle Database Tip: Dropping Tables without Errors

Tuesday Apr 20th 2021 by Octavia Andreea Anghel
Article Image

In this quick Oracle database tutorial, you will learn how to drop tables from a database without receiving any errors.

Sometimes when you drop tables in an Oracle database you will get errors. This is how you drop tables in Oracle without getting errors:

BEGIN
   EXECUTE IMMEDIATE 'DROP TABLE "TABLE_FOO" CASCADE CONSTRAINTS';
EXCEPTION
   WHEN OTHERS THEN NULL;
END;
/
Home
Mobile Site | Full Site