To clarify - I want to be able to notice that the digit count including decimal point is > 16 without having to manually count them. DB Visualizer IS displaying the larger values quite well but they blend in to all the other numbers.
Hi Andrew,
The formatting of a cell in a DbVisualizer grid is configured in Tool Properties -> General -> Data Formats. A quick way to open this is to select the cell in the Grid and click on the format pattern visible in the bottom part of the grid.
The format pattern used for Decimal Numbers are following the syntax of DecimalFormat. An example to achieve Scientific Notation is to use the pattern ##0.#####E0.
I have not found any way to get different formats for numbers larger than a specific value.
I would think the only option is to solve this in SQL.
Kind regards,
Ulf
Andrew Chandler
I'm trying to figure out a way to easily see result columns from an oracle query that maybe have more than 16 digits total. The underlying oracle database supports much more than this but I'm troubleshooting other systems the data flows to. I remember in older versions that if the number got too large it used to display engineering notation for that cell but newer versions seem to just happily show the entire number. Is there a way for me to force the cell's to show no more than 16 digits and user engineering notation if the number is too large or has too many decimals?