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'

NAME

SQL::Exec::Oracle - Specific support for the DBD::Oracle DBI driver in SQL::Exec

SYNOPSIS

use SQL::Exec::Oracle;

SQL::Exec::Oracle::connect($server, $instance, $user, $password);

BUGS

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.

SEE ALSO

SQL::Exec

AUTHOR

Mathias Kende (mathias@cpan.org)

COPYRIGHT & LICENSE

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.