File indexing completed on 2024-04-06 12:22:59
0001
0002
0003 BEGIN
0004 FOR result IN (SELECT table_name FROM user_tables)
0005 LOOP
0006 EXECUTE IMMEDIATE 'DROP TABLE ' || result.table_name || ' CASCADE CONSTRAINTS';
0007 END LOOP;
0008 END;
0009 /
0010
0011 BEGIN
0012 FOR result IN (SELECT view_name FROM user_views)
0013 LOOP
0014 EXECUTE IMMEDIATE 'DROP VIEW ' || result.view_name;
0015 END LOOP;
0016 END;
0017 /
0018
0019
0020 BEGIN
0021 FOR result IN (SELECT sequence_name FROM user_sequences)
0022 LOOP
0023 EXECUTE IMMEDIATE 'DROP SEQUENCE ' || result.sequence_name;
0024 END LOOP;
0025 END;
0026 /
0027
0028 BEGIN
0029 FOR result IN (SELECT object_name FROM user_procedures)
0030 LOOP
0031 EXECUTE IMMEDIATE 'DROP PROCEDURE ' || result.object_name;
0032 END LOOP;
0033 END;
0034 /
0035
0036
0037 BEGIN
0038 FOR result IN (SELECT object_name AS FUNCTION FROM user_objects WHERE object_type = 'FUNCTION')
0039 LOOP
0040 EXECUTE IMMEDIATE 'DROP FUNCTION ' || result.function;
0041 END LOOP;
0042 END;
0043 /
0044
0045
0046 BEGIN
0047 FOR result IN (SELECT trigger_name, table_name FROM user_triggers WHERE trigger_name NOT LIKE 'BIN%')
0048 LOOP
0049 EXECUTE IMMEDIATE 'DROP TRIGGER ' || result.trigger_name;
0050 END LOOP;
0051 END;
0052 /
0053
0054
0055 BEGIN
0056 FOR result IN (SELECT db_link, username FROM user_db_links)
0057 LOOP
0058 EXECUTE IMMEDIATE 'DROP DATABASE LINK ' || result.db_link;
0059 END LOOP;
0060 END;
0061 /
