Drop all DB objects - Oracle
Created this for future reference.
This SQL goes and drops all user objects in the current DB, great when messing with local Oracle XS DB
declarev_str1 varchar2(200) := null;
cursor get_sql is select 'drop '||o.object_type||' '|| o.object_name|| DECODE(o.OBJECT_TYPE,'TABLE',' CASCADE CONSTRAINTS PURGE') v_str1
from user_objects o
where o.object_type in ('TABLE','VIEW','PACKAGE','TYPE','PROCEDURE','FUNCTION','TRIGGER','SEQUENCE') order by object_type,object_name;begin
open get_sql;
loop
fetch get_sql into v_str1;
if get_sql%notfound
then exit;
end if;
execute immediate v_str1;
end loop;
close get_sql;
end;
I did ennjoyed reading this content
ReplyDeleteAivivu chuyên vé máy bay, tham khảo
ReplyDeletegia ve may bay di my
vé máy bay từ mỹ về việt nam giá rẻ
vé máy bay từ canada về việt nam giá rẻ
chuyến bay thương mại từ nhật về việt nam
giá vé máy bay hàn quốc về việt nam
Vé máy bay từ Đài Loan về VN
chuyen bay chuyen gia ve viet nam
You got it! I’ll be here when you’re ready for round two. Catch you soon and take care until then! Pakistani Clothes UK
ReplyDelete