I am currently working on Oracle 18.104.22.168. Below is my requirement.
1.I would like to scan the database ( Eg. 1 entire schema) and need to find the DB object either Procedure/Funcation which is having DROP statement.
( some of the procedures having " DROP PROCEDURE <PROCEDURE_NAME> " statements.
Need to take the list of those objects ( having the DROP statements). (in Excel/CSV)
- Then need to drop only those objects from the schema.
Can any one please advise.