Question: Write a PL/SQL function that will self-destruct the database ( This message will self-destruct in 10 seconds ). We will drop all of the triggers,
Write a PL/SQL function that will self-destruct the database (This message will self-destruct in 10 seconds). We will drop all of the triggers, procedures, functions and tables defined in the database.
You can find triggers in ALL_TRIGGERS table (note: you should only be dropping triggers where YOU are the TABLE_OWNER!). ALL_PROCEDURES stores both functions and procedures (again, do not attempt to drop system owned entries you wont have permission to do so, but lets not scare the DBAs unnecessarily). USER_TABLES contains the list of all user tables.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
