how to compile invalid objects in oracle Etiketli Yazılar

ORACLE – Invalid objeleri toplu olarak compile etmek

Select 'ALTER ' || OBJECT_TYPE || ' ' || OWNER || '.' || OBJECT_NAME || ' COMPILE;'
 From dba_objects
 where status = 'INVALID'
 and object_type in ('PACKAGE','FUNCTION','PROCEDURE','VIEW');