Oracle Apps View: ALL_TAB_COLUMNS; columns: LOW_VALUE and HIGH_VALUE

Question

What are the values in this View: ALL_TAB_COLUMNS view columns: LOW_VALUE and HIGH_VALUE

I was hoping it would be the actual values in the in the view results. I have a query that I use to find data sources for custom report development where this type of data would be very helpful. Is there another table or view which would have the actual low value and high values?

It would be icing on the cake is this data exists.

Answer 1

Yes, these columns contain the actual high and low table values. They are used by the optimizer, collected by the gather statistics run. The data is stored in raw format and you would need to convert it to see the actual values:

select
decode(dtc.data_type,'VARCHAR2',utl_raw.cast_to_varchar2(dtc.low_value)) low_value_char,
decode(dtc.data_type,'VARCHAR2',utl_raw.cast_to_varchar2(dtc.high_value)) high_value_char,
dtc.*
from
dba_tab_columns dtc
where
dtc.owner='AR' and
dtc.table_name='HZ_PARTIES'

Answer 2

These are the results of the first solution provided.