schemaoracle-apps

Oracle Apps View: ALL_TAB_COLUMNS; columns: LOW_VALUE and HIGH_VALUE


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.


Solution

  • 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'