Script to drop all table in a oracle database

drop_all_tables_oracle.sql

-- drop all tables in current schema
declare
   table_name varchar2(30);
   cursor usertables is select * from user_tables where table_name not like 'BIN$%';
begin
   for next_row in usertables
   loop
      execute immediate 'drop table ' || next_row.table_name || ' cascade constraints';
   end loop;
   
-- drop all sequences   
   FOR i IN (SELECT sequence_name FROM user_sequences) 
     LOOP 
       EXECUTE IMMEDIATE('DROP SEQUENCE ' || user || '.' || i.sequence_name); 
   END LOOP; 
end;