Drop all tables, constraints, and sequences within an Oracle schema

Drop all tables, constraints, and sequences within an Oracle schema.

refer link: https://snipt.net/Fotinakis/drop-all-tables-and-constraints-within-an-oracle-schema/

BEGIN

FOR c IN (SELECT table_name FROM user_tables) LOOP

EXECUTE IMMEDIATE ('DROP TABLE ' || c.table_name || ' CASCADE CONSTRAINTS');

END LOOP;

FOR s IN (SELECT sequence_name FROM user_sequences) LOOP

EXECUTE IMMEDIATE ('DROP SEQUENCE ' || s.sequence_name);

END LOOP;

END;