I am fetching data from an Oracle table where the field data type is VARCHAR2(6). The values in this field are numbers, 6 characters. I am not able to visualize the data in the histogram tool in the results set. Neither by query builder or by editor.
I found a around by concatenating an alphabet in front of the numeric value. For example, if the true value is 123456, I add ‘T’ in front of 123456 so I get T123456. This will allow me to visualize the data in the histogram tool.
Is this a bug in the histogram tool?