Toad World® Forums

Histogram tool

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?

This looks like a bug to me. I created QAT-1916 to look into this.

Just one question: When you say that you are unable to visualize, do you mean that it gives an error, or that the graph shows nothing at all?

The graph shows nothing.