exploring histogram of a varchar2 column

From: oracledba <oracledba71_at_gmail.com>
Date: Sat, 6 Dec 2014 16:06:55 -0500
Message-ID: <CA+eRr5HeH-C7djwp4KoW0CG0Y4+SJHzQUUNbOQYGKogGc0498w_at_mail.gmail.com>

Hi,

I am trying to understand how Oracle stores varchar2 data type columns in histograms and why it ignores the characters after 6 or 7 characters.

colname ENDPOINT_NUMBER HEX_VALUE                      CHAR_VALUE
                             ENDPOINT_VALUE ENDPOINT_ACTUAL_VALUE


------- --------------- ------------------------------ ---------------

------------------------------------------------

----------------------------------------

V10                   0 4170706c650002c34b2e037ea00000 Apple

339,779,832,781,057,000,000,000,000,000,000,000 Apple

Converting ENDPOINT_NUMBER HEX VALUE 4170706c650002c34b2e037ea00000 to decimal and exclude evrytthing after first 15 digits, then Oracle stores 3.3977983278106E+35.

 In the Hex value 4170706c650002c34b2e037ea00000, I could understand 41 - A 70 - p 70 - p 6c - l 65 - e what 0002c34b2e037ea00000 are? how they are calculated?

Thanks
Antony

--

http://www.freelists.org/webpage/oracle-l Received on Sat Dec 06 2014 - 22:06:55 CET