try this :

set heading off
set pagesize 0
set feedback off

spool xyz.sql

select 'alter package '||object_name||' compile body;'
from user_objects
where object_type = 'PACKAGE BODY'
union
select 'alter package '||object_name||' compile;'
from user_objects
where object_type = 'PACKAGE'
union
select 'alter procedure '||object_name||' compile;'
from user_objects
where object_type = 'PROCEDURE'
union
select 'alter function '||object_name||' compile;'
from user_objects
where object_type = 'FUNCTION';

spool off

@xyz.sql