SQL-Exec
view release on metacpan or search on metacpan
lib/SQL/Exec/Oracle.pm view on Meta::CPAN
=for comment
select 'drop function ' || object_name from user_procedures where object_type = 'FUNCTION'
union all
select 'drop procedure ' || object_name from user_procedures where object_type = 'PROCEDURE'
union all
select 'drop sequence ' || sequence_name from user_sequences
union all
select 'drop view ' || view_name from user_views
union all
select 'drop table ' || table_name || ' cascade constraints' from user_tables
union all
select 'drop package ' || object_name from user_procedures where object_type = 'PACKAGE'
=cut
1;
=encoding utf-8
( run in 0.638 second using v1.01-cache-2.11-cpan-49f99fa48dc )