Here are examples of Oracle SQL queries to get invalid objects.
Get Invalid Objects of Current User in Oracle
Select object_name, object_type, created, last_ddl_time From user_objects Where status != 'VALID'
The output would the database objects which are invalid.
To get the list of invalid objects for other users, run the following SQL query:
Select owner, object_type, object_name From dba_objects Where status != 'VALID' Order by owner, object_type;
The above SQL query will list out all the invalid objects from all the schemas.
To get the invalid database objects for a particular user, use the following SQL query:
Select object_type, object_name From dba_objects Where status != 'VALID' and owner = 'SCOTT' Order by object_type;