SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Column Statistics LOW_VALUE and HIGH_VALUE data format

901823Nov 23 2011 — edited Dec 7 2011

Hi all !

I have searched this forum history for this and found no absolutely no hits - I hope there is someone out there that knows the answer to this ...

I am using Oracle SQL Developer Version 3.0.04 (build MAIN-04-34) - When you select a table from the Connections / Tables list and then click the Statistics tab column statistics for the table are displayed in the lower portion of the screen on the right. My question / problem is I can Not decode the column contents for the columns LOW_VALUE and HIGH_VALUE. Their data format seems to be hex or ??? (sample shown below)

Owner TABLE_NAME COLUMN_NAME NUM_DISTINCT LOW_VALUE HIGH_VALUE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CS164 DOCMETA XTODT 515 777D0B10010101 78C7091E010101
CS164 DOCMETA XCNTRCTADMINNM 24 424F57454E2C204A554459202837343829 57494C4C49414D532C204A494C4C20283131313629

Does anyone know of a way to change the format of these columns to a user readable format ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2012

Added on Nov 23 2011

#sql-developer

2 comments

3,244 views