Oracle/Drop all user tables

select 'drop table '||table_name||' cascade constraints;' from user_tables;

BEGIN
  for c in (select table_name from user_tables) loop
    execute immediate ('drop table '||c.table_name||' cascade constraints');
  end loop;
END;