조씨의 개발 블로그

-- 테이블 SELECT 'DROP TABLE ' || object_name || ' CASCADE CONSTRAINTS;' FROM user_objects WHERE object_type = 'TABLE'; -- 프로시저 SELECT 'DROP PROCEDURE ' || object_name || ';' FROM user_objects WHERE object_type = 'PROCEDURE'; -- 함수 SELECT 'DROP FUNCTION ' || object_name || ';' FROM user_objects WHERE object_type = 'FUNCTION'; -- 시퀀스 SELECT 'DROP SEQUENCE ' || object_name || ';' FROM user_objects WH..