<pre><code>SELECT 'drop procedure ' || object_name || ';' FROM user_objects WHERE object_type = 'PROCEDURE';
</code></pre><pre><code>SELECT 'drop trigger ' || object_name || ';' FROM user_objects WHERE object_type = 'TRIGGER';
</code></pre>



```
SELECT 'drop procedure ' || object_name || ';' FROM user_objects WHERE object_type = 'PROCEDURE';
``` 

```
SELECT 'drop trigger ' || object_name || ';' FROM user_objects WHERE object_type = 'TRIGGER';
```

Leonardo Verissimo | Oracle | Linux

Leonardo Verissimo | Oracle | Linux

Montando comando para drop de todas as triggers ou outros objetos.