I've always been annoyed by the fact I can't just do something like "drop all tables cascade constraints" or similar in my RDBMS....well, while I've been messing around with some DDL/rev.eng. code where it cames in handy I wanted such a feature for Oracle.
I don't remember where I got it from orginally, but here it goes:
select 'drop ' || object_type || ' "' || object_name || '"'
'CLUSTER', ' including tables cascade constraints;',
'TABLE', ' cascade constraints;', ';')
where object_type in (
'CLUSTER', 'TABLE', 'VIEW', 'SEQUENCE', 'SYNONYM', 'FUNCTION',
) and object_name not like 'BIN$%';