************************************************
* Description: SQL for Querying Invalid Objects
* Compatiablity: RDBMS 10g, 11g, 12c
* Date: 19:11 PM EST, 01/20/2017
************************************************


<1> Querying invalid objects within database:
    |
    |__ SQL> select owner, object_name, object_type from dba_objects where owner in ('USER1','USER2') and status='INVALID';
	
                 OWNER                OBJECT_NAME                              OBJECT_TYPE
                 -------------------- ---------------------------------------- -------------------
                 USER1              P_PARSE_ERTS_DATA_INTO                   PROCEDURE