oracle – View to check for spaces or zeros in all columns in all tables

I have a schema in a mapping system that has dozens of tables with columns that have incorrect values:

  • Number columns where the value is zero, but it should be null.
  • Text columns where the value is a space, but it should be null.

I would like to create a dynamic view that users could open in the mapping software that would return a list of columns that have incorrect values:

table_name    column_name    datatype    value    count
—————————————————————————————————-————————————-———————-
roads         width          number      0        500
sidewalks     description    varchar2    (space)  10000
Sidewalks     const_year     number      0        10  

(If the datatype, value, or count columns are difficult or inefficient to generate, I could live without them. I really just need a list of tables and columns that have bad values.)

What would it take to create a view like this in Oracle?