dbms_stats offers a few functions that convert the raw data type found in the columns low_value and high_value of the data dictionary views dba_tab_columns, dba_tab_cols and dba_tab_col_statistics to the datatype of the column. convert_raw_to_bin_double
convert_raw_to_bin_float
convert_raw_to_date
convert_raw_to_number
convert_raw_to_nvarchar
convert_raw_to_rowid
convert_raw_to_varchar2