可以用一段PLSQL BLOCK实现，例如下面就是编译当前用户所属的各个OBJECT（PACKAGE/TRIGGER/FUNCTION/TYPE等）：

declare
ls_sql varchar2(100);
begin
DBMS_OUTPUT.ENABLE (buffer_size=>null);
for ca in (select object_name,object_type from user_procedures where procedure_name is null
union
select distinct object_name,object_type from user_procedures where
procedure_name is not null) loop
ls_sql:='alter '||ca.object_type||' '||ca.object_name||' '||'compile';
dbms_output.put_line(ls_sql);
execute immediate ls_sql;
end loop;
end;
/