Delete all tables, sequences, and views in the database.

You need to create these Delete statements, use the oracle Data dictionary to find all tables, views, and other objects under the user, and splice idioms.

As follows:

Select 'drop table' | table_name | ';' | chr (13) | chr (10) from user_tables; -- delete tables select 'drop view' | view_name | ';' | chr (13) | chr (10) from user_views; -- delete views select 'drop sequence '| sequence_name |'; '| chr (13) | chr (10) from user_sequences; -- delete seqs select 'drop function' | object_name | ';' | chr (13) | chr (10) from user_objects where object_type = 'function '; -- delete functions select 'drop procedure '| object_name |'; '| chr (13) | chr (10) from user_objects where object_type = 'Procedure '; -- delete procedure select 'drop package' | object_name | ';' | chr (13) | chr (10) from user_objects where object_type = 'package'; -- delete pags

Author "lin213-213"