Delete a table if it exists
SQL> BEGIN 2 FOR i IN (SELECT null FROM user_tables WHERE table_name = 'INDIVIDUALS') LOOP 3 EXECUTE IMMEDIATE 'DROP TABLE individuals CASCADE CONSTRAINTS'; 4 END LOOP; 5 END; 6 / PL/SQL procedure successfully completed.