#875

select 'DROP '|| object_type ||' '|| object_name || case when object_Type = 'TABLE' then ' CASCADE CONSTRAINTS' else '' end ||';'--, obj.*
from useR_objects obj
where object_Type not in ('LOB', 'INDEX')
order by object_type, object_name

database, oracle

[Oracle] Drop/Create temp tablespace [Arduino] IoT