generate view, procedure, function, package and trigger compilation script

select 'alter ' || object_type || ' ' || owner || '.' || object_name || ' compile' || ';' from dba_objects where status <> 'VALID' and object_type in ('VIEW', 'SYNONYM', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TRIGGER');

select 'alter ' || object_type || ' ' || owner || '.' || object_name || ' compile' || ';' from dba_objects where object_type in ('VIEW', 'SYNONYM', 'PROCEDURE', 'FUNCTION', 'PACKAGE', 'TRIGGER') and owner in ('jephe');