Script to drop packages 1

[pjeypal]

A simple one.I need a script to drop all packages in a schema where name starts with 'T_%'

 

[LKBrwnDBA]

Try:

set pages 0 trims on feed off ver off term off
spo drop_pkg.sql
select 'DROP '||'object_type||' '||object_name||';'
  from user_objects where object_type = 'PACKAGE';
spo off
@drop_pkg

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: change to:

...where object_type LIKE = 'PACKAGE%';

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb