How Will You Find Total Number Of Invalid Objects In Database?

1.	How Will You Find Total Number Of Invalid Objects In Database?
Answer» SQLPLUS&GT; select count() from dba_objects where STATUS LIKE 'INVALID'; SQLPLUS> select count() from dba_objects where status like 'INVALID';

Answer»

SQLPLUS&GT; select count(*) from dba_objects where STATUS LIKE 'INVALID';

SQLPLUS> select count(*) from dba_objects where status like 'INVALID';

Discussion