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?