Drop all objects from a schema
begin for cur_rec in (
select
object_name,
object_type
from
user_objects
where
object_type in (
'TABLE', 'VIEW', 'MATERIALIZED VIEW', 'PACKAGE',
'PROCEDURE', 'FUNCTION', 'SEQUENCE', 'SYNONYM'
)
)
loop
begin if c...
davidferrol.hashnode.dev1 min read