set Feedback off
set pagesize 0
spool TypeDrop.sql
select distinct 'drop type '||object_name|| ';' from user_objects where object_type='TYPE';
spool off

它打印到TypeDrop.sql：

sql> select distinct 'drop type '||object_name||';' from user_objects where object_type='TYPE';
drop type ADDRESS_OBJTYP; 
drop type PERSON_OBJTYP;                                                                                                                                              
sql> spool off

我如何才能输出drop语句？谢谢