How do I decode entries in USER_HISTOGRAMS ?

When you do a column histogram (statistic analysis), entries are viewable through USER_HISTOGRAMS.

If the column you are analyzing is a date or a number, the values in USER_HISTOGRAMS.ENDPOINT_VALUE contains the actual column value that is the endpoint.

If the column is a character column, then ORACLE converts it into a number which appears as the ENDPOINT_VALUE.

Question: How do you convert the number which appears in the ENDPOINT_VALUE back to whats its real character string in the analyzed column is ?

Thanks

Robert Howlett

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!