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'
SQL::Exec::Oracle - Specific support for the DBD::Oracle DBI driver in SQL::Exec
use SQL::Exec::Oracle; SQL::Exec::Oracle::connect($server, $instance, $user, $password);
Please report any bugs or feature requests to
firstname.lastname@example.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=DBIx-PureSQL.
Mathias Kende (email@example.com)
Copyright 2013 © Mathias Kende. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.