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 )