invlaid views code example

Example: oracle select invalid views

SELECT owner, object_type, object_name
FROM all_objects
WHERE status = 'INVALID'