Some utils queries on Oracle SQL

Search for invalid objects Link to heading 

SELECT * FROM user_objects WHERE status != 'VALID';

Database version Link to heading 

SELECT * FROM V$VERSION;

Search for a column Link to heading

Search in all tables and views

SELECT * FROM user_tab_columns

Search in tables only

SELECT * FROM user_tab_columns
where table_name not in (
    select view_name from user_views
)