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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!