| -- |
| -- Licensed to the Apache Software Foundation (ASF) under one |
| -- or more contributor license agreements. See the NOTICE file |
| -- distributed with this work for additional information |
| -- regarding copyright ownership. The ASF licenses this file |
| -- to you under the Apache License, Version 2.0 (the |
| -- "License"); you may not use this file except in compliance |
| -- with the License. You may obtain a copy of the License at |
| -- |
| -- http://www.apache.org/licenses/LICENSE-2.0 |
| -- |
| -- Unless required by applicable law or agreed to in writing, software |
| -- distributed under the License is distributed on an "AS IS" BASIS, |
| -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| -- See the License for the specific language governing permissions and |
| -- limitations under the License. |
| -- |
| |
| BEGIN |
| FOR cur_rec IN (SELECT object_name, object_type |
| FROM user_objects |
| WHERE object_type IN |
| ('TABLE', |
| 'VIEW', |
| 'PACKAGE', |
| 'PROCEDURE', |
| 'FUNCTION', |
| 'SEQUENCE' |
| )) |
| LOOP |
| BEGIN |
| IF cur_rec.object_type = 'TABLE' |
| THEN |
| EXECUTE IMMEDIATE 'DROP ' |
| || cur_rec.object_type |
| || ' "' |
| || cur_rec.object_name |
| || '" CASCADE CONSTRAINTS'; |
| ELSE |
| EXECUTE IMMEDIATE 'DROP ' |
| || cur_rec.object_type |
| || ' "' |
| || cur_rec.object_name |
| || '"'; |
| END IF; |
| EXCEPTION |
| WHEN OTHERS |
| THEN |
| DBMS_OUTPUT.put_line ( 'FAILED: DROP ' |
| || cur_rec.object_type |
| || ' "' |
| || cur_rec.object_name |
| || '"' |
| ); |
| END; |
| END LOOP; |
| END; |
| / |