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 bug-dbix-puresql@rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=DBIx-PureSQL.
bug-dbix-puresql@rt.cpan.org
SQL::Exec
Mathias Kende (mathias@cpan.org)
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.
To install SQL::Exec, copy and paste the appropriate command in to your terminal.
cpanm
cpanm SQL::Exec
CPAN shell
perl -MCPAN -e shell install SQL::Exec
For more information on module installation, please visit the detailed CPAN module installation guide.