SELECT OWNER, OBJECT_NAME, REGEXP_REPLACE(dbms_metadata.get_ddl(object_type, object_name, owner), '찾을내용', '변경할내용', 1, 0, 'i') || ';' sql FROM dba_objects WHERE owner IN ('스키마') AND status 'VALID' AND object_type IN ('VIEW', 'SYNONYM', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TRIGGER') ORDER BY OWNER, OBJECT_NAME;