Oracle deletes all objects of the current user (tables, views, triggers, stored procedures, functions)



DECLARE
TYPE name_list is TABLE  of VARCHAR2( +);
TYPE type_list is TABLE  of VARCHAR2( -);

Tab_name name_list:=name_list ();
Tab_type type_list:=type_list ();

Sql_strVARCHAR2( -);
BEGIN
SQL_STR:= 'Select Uo.object_name,uo.object_type from user_objects uo where Uo.object_type not in ("'INDEX"',"'LOB"') Order BY uo.object_type Desc';
EXECUTEIMMEDIATE sql_strBULKCOLLECT intoTab_name,tab_type;

forIinchTab_name. First: Tab_name. Last LOOP
SQL_STR:= 'DROP' ||Tab_type (i)|| ' ' ||Tab_name (i);
EXECUTEIMMEDIATE Sql_str;
ENDLOOP;
END;

Oracle deletes all objects of the current user (tables, views, triggers, stored procedures, functions)